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

SumIfs Function - Simple Question (I think!)

The following syntax is accepted;


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

Patrick O'Dea
Patrick O'Dea
  • 2
2 Solutions
Because C2*12 is not a range, which is the expected parameter type.



barry houdiniCommented:
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


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


regards, barry
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:


Patrick O'DeaAuthor Commented:
Thanks folks,

I see the obvious error now- it's late here .... maybe I'm tired!
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now