Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi There
I currently have the function that works fine but i need to put another argument into it and i am struggling. Currently: =SUMIF('Sales Ledger'!B:B,"JAN",'Sales Ledger'!F:F) However, on the Sales ledger page i have another box with different details in. The is in Colum C:C and the current details is Tool Hire. How do i get the query to only add up the sum if cell Colum B has JAN and Colum C has Tool Hire. Thanks David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |