SUMPRODUCT--what else??

D

Dave F

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
 
D

Dave O

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
 
B

Biff

Is this correct?

Yes.

An alternative:

=SUM(SUMIF(E59:p59,{"BAU","BAU STARTS"},E81:p81))

Biff
 
B

Bob Phillips

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)
 
Top