Sum if a cell is not a certain data
 

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

Sum if a cell is not a certain data
 

=SUMIF(A1:A6,"<jonno",B1:B5)
--
Gary''s Student - gsnu201001


"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

Sum if a cell is not a certain data
 

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,

Sum if a cell is not a certain data
 

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

Sum if a cell is not a certain data
 

Thank you very much!!!
--
Jonno


"Gary''s Student" wrote:

=SUMIF(A1:A6,"<jonno",B1:B5)
--
Gary''s Student - gsnu201001


"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

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

Sum if a cell is not a certain data
 

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,

.