sumif function

[Guest]

trying to use two colums, store location number, and department number, to
sumif their cost to an health premium bill. Not sure how to bracket the
formula and wheither or not to use "and" or another sumif or other
david

 

[Guest]

Assuming the health premiums are in col C

=sumproduct(--(A1:A100=store#),--(B1:B100=dept#),C1:C100)

 

[Guest]

thank you for the prompt response, it helped and will help my accounts
payable clerk with allocations.