Hello everyone,    Using Excel XP.

In this example I want to total B1:B4 ONLY if the date in A1:A4 has arrived.
In C1 I have a formula of sum of B1:B4, which I want to equal (B1,B2,B3)
because the dates in A1:A3 are greater than today (Oct 25, 2006).

I used a formula in the B column:    =IF(A1>TODAY(),"",50),   etc for all in
B1:B4.  This formula works but I was wondering if there is an easier way to
write a formula as I  have to write an indiviual formula in column B as the
data will change every month.

                A                                        B
C
--------------------------------------------------------------------------------
    1         10/23/06        =IF(A1>TODAY(),"",50)
=sum(B1:B4)
    2         10/24/06        =IF(A2>TODAY(),"",50)
    3         10/25/06        =IF(A3>TODAY(),"",40)
    4         10/26/06        =IF(A4>TODAY(),"",40)

Michael