sumif function

D

DAB

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
 
D

Duke Carey

Assuming the health premiums are in col C

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

DAB

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