COUNTIFS FORMULA
Can anyone help where the error to this formula is please?
Just trying to count if a date appears in one column and a color appears in another. Should be easy right?
=COUNTIFS(({Range DATE CREATED}, DATE@row),{Range Colour}, "RED")
Best Answer
-
Hello @Ed Gadd,
It looks like you have an extra parentheses around the first criteria set. Try this:
=COUNTIFS({Range DATE CREATED}, DATE@row, {Range Colour}, "RED")
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Answers
-
Hello @Ed Gadd,
It looks like you have an extra parentheses around the first criteria set. Try this:
=COUNTIFS({Range DATE CREATED}, DATE@row, {Range Colour}, "RED")
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle -
Works perfectly, thank you so much.
Help Article Resources
Categories
Check out the Formula Handbook template!