This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / Question for Excel guruI am working on a spreadsheet which has two columns, one indicates catalog, the other is a number. I want to sum numbers for each catalog. How to do that?
Sounds I need to program something like this:
for each row
switch catalog
case A: sum(A) += number
....
-yymeg(cherry);
2005-7-12
{274}
(#2394968@0)
-
use SUMIF() function.
-schen(睹往睹来);
2005-7-12
(#2395003@0)
-
SUMIF(), or auto filter
-7y7(醉里吴音);
2005-7-12
(#2395023@0)