## Daily sums if

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

### Daily sums if

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
Posts: 78863
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Daily sums if

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: 1469
Joined: 08 Jul 2016, 18:53

### Re: Daily sums if

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
Posts: 78863
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Daily sums if

This?

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

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

### Re: Daily sums if

That works, thanks.

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

### Re: Daily sums if

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