I'm trying to sum a list of values in a column, where the date
identifed in each row is = Now. As example:

7/10/06 100.00
7/11/06 200.00
7/12/06 150.00
7/13/06 250.00

My formula (in theory) needs to be something like:

=if(a1=Now(),sum(b1:b4)

If Now = 7/12/06, then I need it to return the sum of 7/12 and 7/13 for
a total of 400.00.
If Now = 7/13/06, then I need it to return the sum of 7/13 for a total
of 250.00.

My formual will ultimately be more complicated than this as between
each date there are 5 rows of information. The date cell is a merge of
these 5 cells, and then each row has values totaling up to 100.00,
200.00 etc., so I'll need to then get these extra values subtracted
out.

I think I can do the last part, if I can just fugure out how to capture
only those values = Now.

Any suggestions?