Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Syntax
I am using excel to track my expenses. One worksheet for each month.
Sometimes I have bills from one company two or three times in a month. I would like to list all of the supplier names on a seperate worksheet & have the monthly total for each supplier. I have been trying to use sumif, but I want the condition to be equal to a cell reference & it does not seem possible. What is the syntax for a sumif statement when the condition is equal to a cell reference? -- Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Syntax | Excel Worksheet Functions | |||
SQL syntax | Excel Worksheet Functions | |||
Indirect and Sumif Syntax Problems | Excel Discussion (Misc queries) | |||
VBA syntax | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |