Daily sums if

bknight
BronzeLounger
Posts: 1457
Joined: 08 Jul 2016, 18:53

Daily sums if

Post by 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

User avatar
HansV
Administrator
Posts: 78774
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Daily sums if

Post by 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")
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1457
Joined: 08 Jul 2016, 18:53

Re: Daily sums if

Post by 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.

User avatar
HansV
Administrator
Posts: 78774
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Daily sums if

Post by HansV »

This?

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

bknight
BronzeLounger
Posts: 1457
Joined: 08 Jul 2016, 18:53

Re: Daily sums if

Post by bknight »

That works, thanks.

snb
4StarLounger
Posts: 596
Joined: 14 Nov 2012, 16:06

Re: Daily sums if

Post by 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.