hello,
I’m trying to get the sum of a column, with specific criteria.
In cell 3B, in the "asbestos" sheet, I would like the sum of column H in the "incidents" sheet matching the criteria:
Incidents sheet:
Column A = asbestos
Column B = January
The code I’ve tried is:
I’m sure there’s really simple solution to this...![]()
((Incidents!$A$4:$A$500=$a$1)*(Incidents!$C$4:$C$500>=$A4)*(Incidents!$C$4:$C$500<=DATE(YEAR($A4),MONTH($A4)+1,1))
Any help much appreciated!
many thanks
Rich
Bookmarks