| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting SUMIF with Wildcard
Can someone please tell what I am doing wrong with the following sumif
statement? When I try each piece separatly I get a number but when I put them together Excel says something is wrong. sumif(QueryFromAccessRedo!E:E,"=#N/A",sumif(QueryFromAccessRedo!B:B,"*NR",QueryFromAc cessRedo!C:C)) Or if you could help me use SUMPRODUCT - I just can't figure it out there either. Any help would be greatly appreciated! Thanks! Shanna |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard with sumif | Excel Discussion (Misc queries) | |||
| Nesting SUMIF formulas | Excel Worksheet Functions | |||
| Nesting SUMIF | Excel Discussion (Misc queries) | |||
| Sumif using wildcard | Excel Worksheet Functions | |||
| SUMIF, wildcard and cell ref | Excel Worksheet Functions | |||
Threaded Mode
