Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |