My workbook consists of a “Jobs” sheet and a “Total Sheet” sheet. I do all the data entry per line on the “Jobs” sheet. The dates will not be in order within the “Jobs” sheet.
From the “Total Sheet”, I am trying to COUNT how many entries within the “Jobs” sheet fall within January (Date column) and contain an E (Status column).
The date column has dates in the following format:
01/05/06
The Status column has either an E or an S only.
I am also trying to do a SUM function based on these dependencies.
I would be grateful for any assistance given.
From the “Total Sheet”, I am trying to COUNT how many entries within the “Jobs” sheet fall within January (Date column) and contain an E (Status column).
The date column has dates in the following format:
01/05/06
The Status column has either an E or an S only.
I am also trying to do a SUM function based on these dependencies.
I would be grateful for any assistance given.