COUNTIFS help

Dan Howe

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}, <>"")

Paul Newcome

@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?

Sameer Karkhanis

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")

Paul Newcome

@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?

Dan Howe

@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.

Paul Newcome

I meant in your screenshot. Exactly what columns are being referenced by the cross sheet references?

Dan Howe

@Paul Newcome forgive me - new user. I'm not sure I understand your question.

Paul Newcome

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.

Dan Howe

@Paul Newcome OH!

do you mean this?

Paul Newcome

Right. Those cross sheet references. Are the columns they are referencing in your screenshot?

Dan Howe

@Paul Newcome That fixed it! Thanks!

Paul Newcome

Happy to help. 👍️