Easier way to write this formula?

[FinancialAnalystKid]

=SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),C_VC_T)+SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),C_ANC_T)+SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),C_ROOM_T)+SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),C_SUPPORT_T)

I tried:
=SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),(C_VC_T+C_ANC_T+C_ROOM_T+C_SUPPORT_T))

The first two parts are the same as you see.
SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),

But I have to sum four other columns.

 

[Oaktree]

What's wrong with the formula you tried?

=SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),(C_VC_T+C_ANC_T+C_ROOM_T+C_SUPPORT_T))

 

[FinancialAnalystKid]

Results in a #VALUE! error

 

[Oaktree]

My usual culprit with a #value error in sumproduct is that the named ranges have different dimensions (i.e. one goes from A1:A17 and the other goes from B1:B16). Would that fix the issue?

 

[Oaktree]

edit. oops. Double posted the same thing. See above.

 

[FinancialAnalystKid]

They are all based on the same dynamic named range. I checked to see if it is covering the range completely for each column and they are.

Is that last formula correct? Am I missing something?

 

[Aladin Akyurek]

They are all based on the same dynamic named range. I checked to see if it is covering the range completely for each column and they are.

Is that last formula correct? Am I missing something?

#VALUE error would result from the presence uf text values like formula blanks in the ranges to sum.

 

[FinancialAnalystKid]

I use the first formula the forumla works without the #VALUE! error. If there was some text formating within that range it would give me an error too? But when I consolodate the formula using:
=SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),(C_VC_T+C_ANC_T+C_ROOM_T+C_SUPPORT_T))
I get an error.

 

[Brian from Maui]

I use the first formula the forumla works without the #VALUE! error. If there was some text formating within that range it would give me an error too? But when I consolodate the formula using:
=SUMPRODUCT(--(C_MONTH=$A6),--(C_PLAN=$H$3),(C_VC_T+C_ANC_T+C_ROOM_T+C_SUPPORT_T))
I get an error.

Any of the named ranges include column headers?

 

[FinancialAnalystKid]

They all have headers...

Here's what my Range refers to:

=OFFSET(CUMULATIVE!$O$1,0,0,COUNTA(CUMULATIVE!$O:$O),1)

All ranges refer to respective columns.