0

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)

Improve this question
2
  • SUMIF(C1:C2,DATE(2021,2,2),A1:A2)
    – Oleg_S
    Mar 9, 2021 at 6:13
  • Thanks. But the sum result will be zero if the date is not 2,2,2021. For example lets do it like this. SUMIF(C1:C2,TODAY(),A1:A2) . So tomorrow the result will be zero. How to keep the result as it was on TODAY() 23:59 as it is the last chance to enter data. and keep it fixed
    – Hassan Almaateeq
    Mar 9, 2021 at 10:43

1 Answer 1

Reset to default
0

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.