LOOKUP Question

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.
 
B

Bob Bridges

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.
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Page numbering with Merged Document and IF statements 1
Excel does not accept text format! 0
Help with lots of formulas 3
Duplicate entry in a column/row 14
Arriving at totals 2
How can the font and size of (all) citation numbers be altered? 1
Match and delete rows on two different sheets from reference numbers 4

Top