Countif and summing a different column

[Dirk]

I am using countif statement to identify an occurence.
The problem is that I need the actual qty which is in
a different column. How would I sum a column only if a
different column on the same row meets the criteria?

Thanks

 

[Paul B]

Dirk, not sure but try this

=SUMIF(F2:F230,"Test",E2:E230)
Sums E2:E230 if Test is in F2:F230

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[J.E. McGimpsey]

One way:

=SUMIF(A:A,criterion,B:B)