SUMPRODUCT--what else??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hey, Dave-
I mocked up a sprdsht and found that yes, the formula is doing what you
interpret it to be doing- with the exception that the corresponding
range e59:p59 ~equals~, not contains, BAU or BAU Starts. (Not to be a
nitpicker, just a detail).

Dave O
 
Why be slow and obtuse

=SUMIF(E59:P59,"BAU",E81:P81)+SUMIF(E59:P59,"BAU STARTS",E81:P81)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top