Merci. I understand what you wrote, but I'm not sure how to apply it to what
I am doing.
Here is what I am trying to do.
I have rows of items that are categorized (for argument, let's call them
"A", "B", and "C"). I want to create totals by category. In Excel, to sum
all records in Category "A" I would type:
=SUMIF(B1:B100, "A", C1:C100),
where B1:B100 contains the category for each record and C1:C100 contains the
value for each record.
Is this possible to do?
|