Help with Conditional Sum

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

I need to sum several columns of data based on 2 criteria
Here is my formula using the Conditional Sum wizard:
={SUM(IF('BOE Sum'!$A$8:$A$152<>"B",IF('BOE Sum'!$B$8:$B$152=411510,'BOE
Sum'!$S$8:$S$152,0),0))}
Problems -
1 - I need the =411510 value to be a cell value (ie A5)
2 - If I try to change anything, the formula no longer functions - the curly
brackets go away and I get #VALUE in the cell.

Is there a better way to do this?

Glen
 
=SUMPRODUCT(-('BOE Sum'!$A$8:$A$152<>"B"),--('BOE Sum'!$B$8:$B$152=A5),'BOE
Sum'!$S$8:$S$152,0),

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
There was slight typo, should have been

=SUMPRODUCT(--('BOE Sum'!$A$8:$A$152<>"B"),--('BOE Sum'!$B$8:$B$152=A5),'BOE
Sum'!$S$8:$S$152,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top