Counting & Summing based on criteria on another column

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?
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A100<>""),--(C2:C100<TODAY()))

and

=SUMPRODUCT(--(A2:A100<>""),--(C2:C100<TODAY()),A2:A100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
C

Chicago D

That's it...THANKS!

Bob Phillips said:
=SUMPRODUCT(--(A2:A100<>""),--(C2:C100<TODAY()))

and

=SUMPRODUCT(--(A2:A100<>""),--(C2:C100<TODAY()),A2:A100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top