Sounds to me like a Pivot Table might be superior to SUMIF/SUMPRODUCT.
PT's will adjust for whatever categories you have listed.

In article ,
WLMPilot wrote:

I have a worksheet that contains 12 "budgets". More like actual
income/expense. Anyway, each line item in each budget has a category, ie CC
for Credit Card Pmts, Gas, Grocery, Income, etc.

I want to use either SUMIF or SUMPRODUCT. The catch is I do not know if
there was a way to "pick up" each category without the possibility of
repeating that category later. Normally, and possibly the only way that I
know of, I would have to manually type in a SUMIF/SUMPRODUCT for each
category, listing the actual category in the formula.

I wanted to try a way that would automatically pick up any new categories,
not already listed.

Hope that makes sense.

Thanks for your help.

Les