| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to nest functions with SUMIF function in excel
I am trying to use 2 variables with the SUMIF function. ie:-
sumif(<range1,<criteria1)(<range2,<criteria2), <sum_range So far, I cannot find out if this is possible. Has anyone tried and managed to do this successfully? I thought maybe that the AND function has to be used ... for example:- Sumif(AND(A:A,"Car"(B:B,"Red",C:C))) - but with this example, I get the error message:- "You've entered too few arguments etc " |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Why not nest more than 7 functions in Excel formula??? | Excel Worksheet Functions | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
| How can I nest more than seven functions in MS Excel? | Excel Worksheet Functions | |||
Threaded Mode
