SUMIFS

[petercooper]

Hi, See attached file, REPORT worksheet I have a SUMIFS in cell D8 that is returning a result of 0, why is this happening with the criteria I am using?

[#2]

@petercooper There is no REPORT worksheet in the file you attached. Neither is there a SUMIF formula in either of the D8 cells on the two sheets that are in the workbook. Please try again.

[#3]

@Riny_van_Eekelen 

Thanks Riny, apologies, please see this attachment.

Regards

Peter

[#4 · Accepted solution]

@petercooper Change D8 into:

=SUMIFS(Occupancy!$D$2:$D$131,Occupancy!$B$2:$B$131,">="&D2,Occupancy!$B$2:$B$131,"<="&E2)

This returns 774. Is that what you expect to see?

[#5]

Thanks Riny, that is exactly what i want to see, thanks for your help.

Regards

Peter