Formulas
I have a report where I track estimate by project manager. I would like to count the estimate that need follow up that are past due for each project manager. I keep getting an unparseable error
=countif([Number of Est]@row,{J&B Estimating Log Range 5},=<TODAY())
"Number of Est" is a reference to the sheet I am working on and the "J&B Estimating Log Range 5" is from other sheet.
Best Answer
-
If you have multiple criteria that you're looking for (a Project Manager and an Overdue Date), then you'll want to use COUNTFS, plural.
A COUNTIFS Function works like this:
=COUNTIFS({Column 1}, "Criteria 1", {Column 2}, "Criteria 2")
So in your case, something like this:
=COUNTIFS({J&B Estimating Log Project Manager Column}, "Project Manager Name", {J&B Estimating Log Range 5}, @cell <= TODAY())
If this hasn't helped, it would be useful to see a screen capture of the sheet you're referencing and your current sheet, but please block out sensitive data.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
for one, CountIf() only has two parameters, the range and the criterion to evaluate for each item in that range. If you delete the [Number of Est]@row part you should at least get past the #UNPARSABLE error, provided of course your range is the correct format/data type.
-
it works that way and yes the UNPARSABLE is clear but it counts all the estimate in the log that are over due. I just want it to count the estimates that need follow up/over due for each Project Manager. Should I be using an IF / AND command
-
If you have multiple criteria that you're looking for (a Project Manager and an Overdue Date), then you'll want to use COUNTFS, plural.
A COUNTIFS Function works like this:
=COUNTIFS({Column 1}, "Criteria 1", {Column 2}, "Criteria 2")
So in your case, something like this:
=COUNTIFS({J&B Estimating Log Project Manager Column}, "Project Manager Name", {J&B Estimating Log Range 5}, @cell <= TODAY())
If this hasn't helped, it would be useful to see a screen capture of the sheet you're referencing and your current sheet, but please block out sensitive data.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Genevieve P,
Thank you that worked perfect.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!