• Status: Solved
• Priority: Medium
• Security: Public
• Views: 252

# SumIfs Function - Simple Question (I think!)

The following syntax is accepted;

=SUMIFS(T2,Q2,"="&4040,C2,"="&1)

However, when I multiply the C2 by 12, I get an error.  Why?

=SUMIFS(T2,Q2,"="&4040,C2*12,"="&1)
0
Patrick O'Dea
• 2
2 Solutions

Commented:
Because C2*12 is not a range, which is the expected parameter type.

Try

=SUMIFS(T2,Q2,4040,C2,1/12)

Thomas
0

Commented:
You can't modify the ranges in any way in SUMIFS so C2*12 isn't valid. If C2*12 should = 1 then wouldn't C2 = 1/12? In which case this version should work

=SUMIFS(T2,Q2,"="&4040,C2,1/12)

although you wouldn't normally need SUMIFS for single cell ranges - are those really your ranges? if so then this should be sufficient

=IF(AND(Q2=4040,C2*12=1),T2,0)

regards, barry
0

Commented:
I was trying to edit my comment to basically say the same thing as barry. Why SUMIFS indeed?

The IF option is an alternative, as is the following:

=(Q2=4040)*(C2/12=1)*T2

Thomas
0

Author Commented:
Thanks folks,

I see the obvious error now- it's late here .... maybe I'm tired!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.