Basic Format Question

H

Heather

Hello, Is there a way to say look in column A. Find all
of the cells in this column that are alike and the sum
their rows? This is probably very simple, but I just
can't get the answer. Thanks.
 
F

Frank Kabel

Hi
not quite sure what you're trying to do (what do you mean with
'alike'9. But have a look at SUMIF
 
M

mickedog

the function "sumif" might do the trick
but that all depends on what kind of data your working wit
 
H

Heather

Sorry, I should have been clearer. What I meant was
below.

Maybe 5 times through the report A03148 is a row that I
want to total. But that is not the only value and each
time I import the report the 6 digit number may be
different, so I want to say ANY exact number in the
column A....I want those rows to add together. I hope
that this makes it more clear. Thank You for all of the
responses.
 
Top