| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested sumif
i need to combine 2 arguments in a SUMIF function so i can use it with Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will work in earlier versions of Excel. here are the 2 SUMIF arguments i need to combine... SUMIF(B1:B50, B50, F1:F50) SUMIF(I1:I50, TRUE, F1:F50) so i need to add the cells in F1:F50 where their corresponding value in I1:I50 is TRUE, and the corresponding value in B1:B50 = B50. can someone help?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif and countif nested? | Excel Worksheet Functions | |||
| If and nested Sumif error | Excel Worksheet Functions | |||
| Nested SumIf statement | Excel Worksheet Functions | |||
| Will a Nested IF/SUMIF function instead of VBA? | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
Threaded Mode
