SUM OF GROUPS
THANKS ...result is what I was looking for
"Bob Phillips" wrote in message
...
=SUMIF(C:C,630,D:D)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"ADK" wrote in message
...
I have two columns.
Column C is labeled: Group
Column D is Labeled: Weight
I have 27 rows with data. I would like to tally the group weights
example: 5 of the 27 rows are under Group number 630 (the cell in column
C
has the value 630). Each one has a weight ...I'd like a total weight for
all
items with the group number 630 and so forth. I am guessing this is maybe
some kind of lookup function but have no idea on how to add each room
with
the same group number.
Thanks in Advance
|