I have a spread sheet where I keep items that I purchase at work. Previously I was only ordering items for 2-3 people, now I am going to be ordering for 12-14 people (3 departments). So I am trying to clean up my spreadsheet some and also make it more functional.
In column G I have "Purchase Order" & in column H I have "Received Date"
What I am wanting to do is count the blank cells in column H. However, with purchasing items from multiple suppliers and multiple months there are spaces to separate each purchase order. So if I just do =COUNTBLANK it will return the wrong number.
I was hoping there was a way to count cells in Column G that had text and if there was text in it to count Column H and see if blank or not, if blank count it, if H has text ignore it.
Example below I want it to count 5&6 but ignore 1,2,3,&4
89094-572, Large DuraFlock Gloves Case 1 $210.58 $210.58 10/15/2014 40056968 10/22/2014
14670-149, General Transfer Pipets Case 1 $416.46 $416.46 10/15/2014 40056968 10/27/2014
L15008, 500g Hydroxyacetone 95% Bottle 1 $83.70 $83.70 10/28/2014 40057361
A14740, 2500g Dichloroacetic Acid 99% Bottle 1 $118.00 $118.00 10/28/2014 40057361