help with =COUNTIFS formula

[redspanna]

Hi all

I have this formula to count the occurrences the same date that is shown in cell T11 is shown through my data held in column A

=COUNTIFS(Log!$A:$A,">="&Dashboard!T11,Log!$D:$D,"<="&EOMONTH(Dashboard!T11,0))

How can this be changed then to simply SUM the values held through column D and not just count them?

I've tried to change the =COUNTIFS to =SUMIFS but I get an error stating "You've entered too few arguments.."

Help appreciate - thanks

 

[Fluff]

I would have to disagree, if somebody doesn't know how to use a countifs or sumifs formula, the chances are that they will not understand an array formula.
The fact that you may not have noticed any difference doesn't mean there isn't one. Personally I tend to steer clear of array entered formulae wherever possible (within reason).

 

[redspanna]

Maybe something like below
On phone so haven't checked
Ps is dashboard T11 today's date

=SUMIFS (Log!$D:$D, Log!$A:$A,">="&Dashboard!T11,Log!$A:$A,"<="&EOMONTH(Dashboard!T11,0))

That's great - thanks a lot