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 10 Feb 2010 10:06
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: Gary''s Student on 10 Feb 2010 10:16
=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
From: Bob I on 10 Feb 2010 10:18
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,

From: Jim Thomlinson on 10 Feb 2010 10:22
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:17
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
 |  Next  |  Last
Pages: 1 2
Prev: How to turn off accepting the licensing agreement when open excel
Next: Making the text in a cell with a money format centered