Daily sums if

[bknight]

I have a formula

Code: Select all

=IF(B3=0,"During 2023 $ "&FIXED(SUMIFS(G7:G1233,E7:E1233,">10/01/2023",E7:E1233,"<10/03/2024")),"Open")

It was intended to be a daily sum but I would be required to change two numbers every day to view the sum every day. Is there a way to make it more automatic, in other words change every day it is opened? Note the string "During 2023 $ " is not correct and would be required ti say something like Daily

[HansV]

Does this do what you want?

=IF(B3=0,"Sum to Date $ "&FIXED(SUMIFS(G7:G1233,E7:E1233,">10/01/2023",E7:E1233,"<="&TODAY())),"Open")

[bknight]

I may not have asked the correct question I want to view the sum on a daily basis, not a sum of all data greater than 10/01/2023.

[HansV]

This?

=IF(B3=0,"Daily $ "&FIXED(SUMIFS(G7:G1233,E7:E1233,TODAY())),"Open")

[bknight]

That works, thanks.

[snb]

In a dynamic table containing a 'Totals' row, it will be done without any formula if you use the builtin autofilters in the Table.