SumIf help please

[CK]

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

 

[Roger Govier]

Hi

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

 

[Guest]

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

 

[CK]

Yes theses formulas worked beautifully. Thanks all!
~ck