View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default SUMPRODUCT--what else??

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.