SUMIFS forumula
Answers
-
Hey @MarianneS
Are you wanting to Count or are you wanting to Sum?
If only want to count the number of occurrences, use a COUNTIFS formula.
COUNTIFS({Project Type}, "Event Coverage", {Project Status}, "Complete", {Month Identifier}, "January", {Year Identifier}, 2024)
Note that numbers are not enclosed by quotes, textstrings are enclosed in quotes.
If you want the sum, the field that is being summed must be numeric data. The syntax of the SUMIFS formula is
=SUMIFS({range to be summed}, {range of criteria #1}, {criteria #1}, {Range of criteria #2}, {criteria #2},etc)
The posted formula is missing the 'Range to be summed'.
Does this work for you?
Kelly
-
Hi @Kelly Moore ,
I am wanting to count the number of times the word "Event Coverage" appears in our booking form under Project Type that is completed in "January" in "2024"does that make sense? I've changed the formula to countifs but now getting invalid Ref.
=COUNTIFS({Project Type}, "Event Coverage", {Project Status}, "Complete", {Month Identifier}, "January", {Year Identifier}, "2024")
sorry for my ignorance, but is the Project Type not the range to be summed?
-
Invalid Reference means that your references (items in curly brackets) are not properly referenced. Are they in another sheet? If yes, please double check them, if they are in the same sheet, use
[Colum Name]:[Column Name]
format when referencing....
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!