COUNTIFS help
I have this formula but its's not counting correctly. I want to show a count of the Date Received column that have been delivered.
=COUNTIFS({Gear Ship Schedule Template Platt Item}, AND(@cell <> "Qty", @cell <> ""), {Gear Ship Schedule Template Delivered}, <>"")
Best Answer
-
@Sameer Karkhanis You can use AND and OR functions within COUNTIFS. I use them both very very frequently both for my own use and as parts of other solutions posted here in the Community.
@Dan Howe Which column(s) are your cross sheet references pointing towards?
Answers
-
I don't think you can use logical expressions in COUNTIFS criteria. Also COUNTIFS by default does not match anything that is blank so the <>"" condition is redundant anyway, so you can also simply use COUNTIF instead unless you have specific text to equate or not equate to.
=COUNTIFS({Gear Ship Schedule Template Platt Item}, <>"Qty")
-
@Sameer Karkhanis You can use AND and OR functions within COUNTIFS. I use them both very very frequently both for my own use and as parts of other solutions posted here in the Community.
@Dan Howe Which column(s) are your cross sheet references pointing towards?
-
@Paul Newcome The indicated cross reference columns (Quantity and Date Shipped) are running a similar formula to calculate/graph how many items have shipped.
This formula is to run the same type of result, but my project managers always include the person signing for deliver in the Date Received column, so a straight date reference won't work.
It needs to trigger if the Date received is not blank.
-
I meant in your screenshot. Exactly what columns are being referenced by the cross sheet references?
-
@Paul Newcome forgive me - new user. I'm not sure I understand your question.
-
When you created your cross sheet references in your formula, which columns did you select to be evaluated? I do not see them in your screenshot.
-
@Paul Newcome OH!
do you mean this?
-
Right. Those cross sheet references. Are the columns they are referencing in your screenshot?
-
@Paul Newcome That fixed it! Thanks!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 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!