First, thanks in advance for taking the time to read this, so here goes....
I'm trying to total the number of cells(Blank or Not) in a column based on two criteria-
1- one of two types of equipment(A or B)-Column A= Equipment
2- if the equipment is online(Column B= Online Date); once online the words "Not on Line" are replaced with the unit's online date.
I've got the invoicing formula nailed,-we bill commencing 1 year after the online date-
but i need to get totals of online equipment by type under each month. Since we don't bill for a year, somebody suggested I just total the column for a year ahead, but my boss doesn't want that.
Suggestions?
I've uploaded a sample sheet.
Thanks in advance,
Jim B