sumif function
 

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

sumif function
 

Assuming the health premiums are in col C

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

"DAB" wrote:

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

sumif function
 

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

"Duke Carey" wrote:

Assuming the health premiums are in col C

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

"DAB" wrote:

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