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]

Are the values in col D dates?

 

[redspanna]

Are the values in col D dates?

No, just numbers

 

[Fluff]

Then why are you comparing it to a date?

 

[redspanna]

Then why are you comparing it to a date?

I just want the total sum of any values entered through column D of the "LOG" worksheet if the date (mmm,yy) in cell T11 of the Dashboard worksheet matches any of the dates through column A of the Log worksheet

sorry for any confusion

 

[Fluff]

With the countifs formula you posted should that be looking at col A in both parts of the formula, rather than col A & D

 

[rhombus4]

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))

 

[Corbett]

Array formulas can be quite elegant. I don't have access to Excel 2016 but I think CSE should work with

[B]=SUM((Log!$A:$A=Dashboard!T11)*Log!$D:$D)[/B]

 

[Fluff]

Why would you want to use an array formula rather than a simple sumifs, which would be far more efficient? Especially when using entire column references.

 

[Corbett]

I would question whether SUMIFS is in fact simple and the fact that questions about it crop up frequently would bear that out. Also I've never noticed any difference in efficiency between array formulas and sumifs. Once you have mastered array formulae they are considerably more powerful and flexible than what you can achieve with SUMIFS and its relatives. exceljet.net gives a really good overview of array formulae.