Using IF Statement with COUNTIFS and also checking if cell is blank in COUNTIFS
I have a quick formula question I can’t seem to figure out. I have two worksheets with the following names. One is ‘BY Load‘, the other is ‘Inventory Check‘. I have a list of numbers (loadnum) on the ‘BY Load‘ in column F. I have the same item number list (Could be in a different order) (This column name on this sheet is LICENSE_PLATE) on the ‘Inventory Check‘ worksheet in column A. I also have a mandate column on worksheet ‘BY Load‘ in column AC and a MFG_DATE column on sheet ‘Inventory Check‘ in column K. Within these sheets I’m looking to see if the mfg date matches for the items.
Count If criteria partial text
How can I count number of cells in a column that contains partial text
Count If criteria partial text
How can I count number of cells in a column that contains partial text