sumif or sumifs

%3CLINGO-SUB%20id%3D%22lingo-sub-2217855%22%20slang%3D%22en-US%22%3Esumif%20or%20sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217855%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20the%20attached%20spreadsheet%20I%20want%20to%20total%20cell%20f89%20if%20it%20equals%20cell%20b87%20with%20the%20date%20range%20in%20a2%3Aa83%20in%20order%20to%20total%20f2%3Af83.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20want%20to%20total%20the%20items%20for%20%22Bristol%20Hauling%22%20that%20occur%20in%20the%20month%20that%20I%20specify%20in%20Cell%20b87.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2217855%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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??

 

Thanks

2 Replies

@Larry1921 

The syntax is

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

@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))