Good day, all.
My issue is I am lead to believe I am looking for a countif countblank function to achieve my goal. I am looking to count all the ranges with names and no dates in the top right corner, Cell AZ2. The numbers should be 8 as seen in February I am looking to put the function on the sheet2, cell H2
I also have an issue with the Dep accession counter at the top. Similar to my above issue. If there is a number in the ship date range it will be counted. I need it to not to count if the name column has no name. As seen in the month of March. When numbers are deleted, it should be 36 in block A02
I greatly appreciate your time and assistance.
Project 212
My issue is I am lead to believe I am looking for a countif countblank function to achieve my goal. I am looking to count all the ranges with names and no dates in the top right corner, Cell AZ2. The numbers should be 8 as seen in February I am looking to put the function on the sheet2, cell H2
I also have an issue with the Dep accession counter at the top. Similar to my above issue. If there is a number in the ship date range it will be counted. I need it to not to count if the name column has no name. As seen in the month of March. When numbers are deleted, it should be 36 in block A02
I greatly appreciate your time and assistance.
Project 212