C
Chicago D
I have a spreadsheet of estimate date that is incomplete (some cells have
data, some do not yet). I need to be able to count the number of estimates
(col A in the simple example below) that are for completed phases (col
C)...in other words, the date in col C is in the past. I'll also need to be
able sum col A for all completed phases (but this can be done in another
cell). In the example below, I would expect the estimate count to be 2 and
the estimate sum to be 4500.
A B C
1 Estimate Actual Phase Completion Date
2 1000 1200 7/12/2005
3
4 3000 6/30/2005
5 2178 10/1/2005
6 3500 3379 5/14/2004
Any suggestions?
data, some do not yet). I need to be able to count the number of estimates
(col A in the simple example below) that are for completed phases (col
C)...in other words, the date in col C is in the past. I'll also need to be
able sum col A for all completed phases (but this can be done in another
cell). In the example below, I would expect the estimate count to be 2 and
the estimate sum to be 4500.
A B C
1 Estimate Actual Phase Completion Date
2 1000 1200 7/12/2005
3
4 3000 6/30/2005
5 2178 10/1/2005
6 3500 3379 5/14/2004
Any suggestions?