Sum if a cell is not a certain data
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
|