Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm auditing a spreadsheet with the following formula:
=SUMPRODUCT((E81:P81)*(E59:P59="BAU"))+SUMPRODUCT( (E81:P81)*(E59:P59="BAU Starts")) I'm looking for confirmation that the following is the correct interpretation of what this formula is doing: 1) Sum those cells in the range E81:P81 for which the corresponding cell in range E59:P59 contains "BAU" 2) Sum those cells in the range E81:P81 for which the corresponding cell in range E59:P59 contains "BAU Starts" 3) Add the results of 1) and 2) together. Is this correct? Thx, Dave -- Brevity is the soul of wit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |