Sum if a cell is not a certain data

  • Thread starter Thread starter Jonno
  • Start date Start date
J

Jonno

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,
 
A couple of possible solutions...
With SumIf
=SUM(B2:B10) - SUMIF(A2:A10, "=Jonno", B2:B10)
With SumProduct
=SUMPRODUCT(--(A2:A10<>"Jonno"), B2:B10)
 
Thank you very much!!!
--
Jonno


Jim Thomlinson said:
A couple of possible solutions...
With SumIf
=SUM(B2:B10) - SUMIF(A2:A10, "=Jonno", B2:B10)
With SumProduct
=SUMPRODUCT(--(A2:A10<>"Jonno"), B2:B10)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup and count all cells that fall between 2 dates 3
Dynamic Sum Array Formula Input Help 3
Excel formula, sum the value cell and if empty cell left blank 0
Cell not calculating after importing data 2
Sum value in all columns that their title is the same 1
sumif for a specific number of cells 2
Error calculation 2
Dynamic Sum-if function 5

Back
Top