sumif or sumifs

Occasional Contributor

On the attached spreadsheet I want to total cell f89 if it equals cell b87 with the date range in a2:a83 in order to total f2:f83.


Basically I want to total the items for "Bristol Hauling" that occur in the month that I specify in Cell b87.


Can someone help??



2 Replies


The syntax is



Another variants