sumif or sumifs

[Larry1921]

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??

Thanks

[#2]

@Larry1921 

The syntax is

=SUMIFS(F$2:F$84,$A$2:$A$84,$B$87,$B$2:$B$84,$B89)

[#3]

@Larry1921 

Another variants

=IFERROR(SUM(FILTER(F$2:F$84,($A$2:$A$84=$B$87)*($B$2:$B$84=$B89))),0)

=SUMPRODUCT(F$2:F$84*($A$2:$A$84=$B$87)*($B$2:$B$84=$B89))