Help with SUMIFS

C

chemexhants

New member
Joined
Oct 20, 2015
Messages
1
Reaction score
0
Points
0
Hi

I have a spreadsheet which is using SUMIF. I need to extend the range so that the data is also searched within a date range. SUMIFS seems to be the obvious way but I haven't been able to get the date range to work.

Can anyone help me with this please?

Stephen
 

Attachments

  • Sample Sales Database 2015-16.xlsx
    73.9 KB · Views: 13
On Sheet1 in the helper 'E' column set the formula
Code: 
=TEXT(DATE(YEAR(B1);MONTH(B1);DAY(B1));"mmm")
On Sheet2 set the formula
Code: 
=SUMIFS(Data!$D$1:$D$1400;Data!$A$1:$A$1400;$C7;Data!$E$1:$E$1400;D$4)
or
Code: 
=SUMPRODUCT(($C7=Data!$A$1:$A$1400)*(D$4=Data!$E$1:$E$1400)*(Data!$D$1:$D$1400))
 

Attachments

  • chemexhants-navic.xlsx
    81.6 KB · Views: 13
You must log in or register to reply here.
Back
Top