SumIf help please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CK - 28 Jun 2007 17:23 GMT

I want to sum column values if the adjacent cell has the word "Written" in
it. Any help? I am sure excel can do this.

Thanks In Advance,
~ck

Reply to this Message

Roger Govier - 28 Jun 2007 17:35 GMT

Hi

Try
=SUMIF(A:A,"Written",B:B)

Signature

Regards

Roger Govier

>I want to sum column values if the adjacent cell has the word "Written"
>in it. Any help? I am sure excel can do this.
>
> Thanks In Advance,
> ~ck

Reply to this Message

CK - 28 Jun 2007 17:59 GMT

Yes theses formulas worked beautifully. Thanks all!
~ck

> Hi
>
[quoted text clipped - 6 lines]
>> Thanks In Advance,
>> ~ck

Reply to this Message

Ron Coderre - 28 Jun 2007 17:36 GMT

With these values in A1:B3
1    written
10    verbal
100    written

This formula returns the sum of Col_A values where the corresponding Col_B
value is "written"
=SUMIF(B1:B3,"written",A1:A3)

In the above example, the formula returns 101

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

> I want to sum column values if the adjacent cell has the word "Written" in
> it. Any help? I am sure excel can do this.
>
> Thanks In Advance,
> ~ck

Reply to this Message