Writing a formula...is there an easier way?

[Mike]

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

 

[Biff]

Try this:

=SUMIF(A1:A4,">"&TODAY(),B1:B4)

Or, depending on what you mean by: "if the date in A1:A4 has arrived"

=SUMIF(A1:A4,">="&TODAY(),B1:B4)

Biff