redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
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
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