Countif and summing a different column

  • Thread starter Thread starter Dirk
  • Start date Start date
D

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
 
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 **
 
Back
Top