LOOKUP Question
 

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.

LOOKUP Question
 

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.

--- "Tam" wrote:
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.

LOOKUP Question
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tam" wrote:

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.

LOOKUP Question
 

Hello,

Maybe my UDF's Sfreq or Pfreq can help he
http://www.sulprobil.com

Regards,
Bernd