LOOKUP Question

  • Thread starter Thread starter Tam
  • Start date Start date
T

Tam

I have a table with several columns,one of which is a column of numbers from
(1-15) that reference a certain item. There are several instances of the
same numbers. I need a formula that will reference this column of numbers,
add however many 1's, or 5's, or 12's, etc. and return that value.
 
If you want to count the 5s (or whatever), use COUNTIF. If you want to sum
the values in another column that correspond to the 5s, use SUMIF. I don't
use 'em very often, but they're very handy occasionally.
 
I think you're looking for something like:
=COUNTIF(A2:A100,1)
which counts how many 1's occur in the range a2:a100.

The other similar formula is
=SUMIF(A2:A100,5)
Which would sum all the values equal to 5. I.e., if there are four 5's in
the range, formula will return a value of 20.
 
Back
Top