Sum if a cell is not a certain data
in [General]
|
Prev: How to turn off accepting the licensing agreement when open excel
Next: Making the text in a cell with a money format centered
From: Jonno on 12 Feb 2010 05:18 Thank you very much!!! -- Jonno "Jim Thomlinson" wrote: > A couple of possible solutions... > With SumIf > =SUM(B2:B10) - SUMIF(A2:A10, "=Jonno", B2:B10) > With SumProduct > =SUMPRODUCT(--(A2:A10<>"Jonno"), B2:B10) > -- > HTH... > > Jim Thomlinson > > > "Jonno" wrote: > > > Hi, > > > > I have a set off data like this...... > > > > Jonno 3 > > Alex 5 > > Jonno 5 > > Simon 5 > > Simon 5 > > Alex 3 > > > > and i have a formula to calculate the total sum of jonno's (i.e 8) > > > > but i would like it to calculate if its not jonno i.e simon and alex (18) > > > > am thinking this will be possible but i cannot figure out how. > > > > Thanks in advance, > > -- > > Jonno
From: Jonno on 12 Feb 2010 05:18
Thank you very much!!! -- Jonno "Bob I" wrote: > total sum - sum of jonno's > > Jonno wrote: > > Hi, > > > > I have a set off data like this...... > > > > Jonno 3 > > Alex 5 > > Jonno 5 > > Simon 5 > > Simon 5 > > Alex 3 > > > > and i have a formula to calculate the total sum of jonno's (i.e 8) > > > > but i would like it to calculate if its not jonno i.e simon and alex (18) > > > > am thinking this will be possible but i cannot figure out how. > > > > Thanks in advance, > > . > |