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
|