If I want to sum of dynamic cell values (numbers) across range if date is specific (like 2 Feb 2021) and keep the maximum result fixed so I can draw a chart of percent reached.. Like elections for example..
If i type: sumif(A1:A2,C2=2/Feb/2021)
Google-sheets – How to sum range of values if date =specific date but keep result fixed next day
google sheets
Related Topic
- Google-sheets – Run a formula multiple times in same sitting
- Google-sheets – Sum the numeric part of cells that contain specific strings
- Google Sheets – Calculate Only if Cell Contains a Number
- How to Insert Numerical Values in a Google Sheet Cell and Find Their Sum
- Google-sheets – Google Sheets – summing numbers across a spreadsheet depending on the Column header
- Google-sheets – How to sum amount with a criteria separately by day in Google Sheets
- Google-sheets – Removing values in array without filter() in Google Sheets
- Google-sheets – How to sum up values within Google Sheet cells under a specific condition
Best Answer
It was solved by adding a helper column that will ass the date.time automatically based on OnEdit trigger of a range of cells or column. Then you could countif range based on specific date criteria in that helper column. Thanks to @Rubén