NEED HELP WITH A BUNCH OF FORMULAS IN A SHEET SUMMARY
Answers
-
Hey @Angie F
The syntax for COUNTIFS is that after each range you're looking in, you need a comma before listing the criteria:
=COUNTIFS(range , criteria , range2 , criteria2)
Think of it like when you set up a filter... one dropdown selection is the column, the other dropdown selection is what you're looking for. These are two separate dropdowns. The way the formula can tell the separation is by the comma!
In your formula above, there is no comma between {Software} and what you're looking for. Try adding a comma before the = sign.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Hi @Angie F you're missing a comma after {Software}
-
I have looked at this way too much! Thank you both!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find t…
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…
- I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1…