SUMPRODUCT--what else??
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)
"Biff" wrote in message
...
Is this correct?
Yes.
An alternative:
=SUM(SUMIF(E59:P59,{"BAU","BAU STARTS"},E81:P81))
Biff
"Dave F" wrote in message
...
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.
|