Sign in to join the conversation:
I would like to count how many of my orders do not have PO number (i.e Po Number cell is blank)
Can you help with the formula to do this
Thanks
Try this formula.
=COUNTIFS([PO Number]:[PO Number], ISBLANK(@cell))
Make sure your column title is PO Number. If it's different update my formula to match.
I would suggest adding in additional criteria for another column that is always populated. That way your formula doesn't include the blank rows at the bottom of the sheet.
If you have a date type column that will always have a date in it regardless of whether or not there is a PO Number, you could use something along the lines of...
=COUNTIFS([PO Number]:[PO Number], ISBLANK(@cell), [Date Column]:[Date Column], ISDATE(@cell))
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
