Good Afternoon (AEST) Aust,
Searching for a formula for the following:
Fields A1:A100 are filled with 4 specific dates (one is eg, 01-Aug-12) and Fields B1:B100 filled with YES or NO.
I need to conform to Excel 2003, to add the number of "01-Aug-12" if Col B returns a "YES".
Tried some of the formulas in the forum but not much luck, hence Excel 2003.
Searching for a formula for the following:
Fields A1:A100 are filled with 4 specific dates (one is eg, 01-Aug-12) and Fields B1:B100 filled with YES or NO.
I need to conform to Excel 2003, to add the number of "01-Aug-12" if Col B returns a "YES".
Tried some of the formulas in the forum but not much luck, hence Excel 2003.