Basic Format Question

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

 

[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

 

[mickedog]

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

 

[Don Guillett]

It depends of your definition of "alike"

 

[mickedog]

perhaps just a simple "if" would do the trick


=if(a1:d1) = "a",sum(a2:a10),"

 

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

 

[David McRitchie]

Hi Heather,
then you already have your answer in SUMIF an example in
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel/sumdata.htm#count