Need help with a problem.

[Tom Snuggs]

I could use some help with this. It's probably an easy solution that I'm
just overlooking. I have a column (L) that contains both blank cells and
cells that have dates in them in */**/**** format. I have another column
(H) that contains dollar amounts. What I want to do is SUM the dollar
amounts in column H only for rows that have a date in column (L).

How do I write a formula that would do this AND ignore dates before and
after certain preset dates, say after May 30 and before July 1, so that only
dates in June would be used to sum column (H)? I can't figure out how to
get the formula to use the dates as criteria for a SUMIF function.

Any suggestions would be greatly appreciated.

Thanks,

TDS

 

[Rod]

Hello,

You can do this via the IF statement with a comibnation
of the AND statement and the OR statement. You can also
change the look of the successful result with conditional
formatting of the cell.

Cheers

 

[Bob Phillips]

Tom,

Try
=SUMPRODUCT((L1:L20>DATE(2003,5,30))*(L1:L20<DATE(2003,7,1))*(H1:H20))

 

[Ron Rosenfeld]

I could use some help with this. It's probably an easy solution that I'm
just overlooking. I have a column (L) that contains both blank cells and
cells that have dates in them in */**/**** format. I have another column
(H) that contains dollar amounts. What I want to do is SUM the dollar
amounts in column H only for rows that have a date in column (L).

How do I write a formula that would do this AND ignore dates before and
after certain preset dates, say after May 30 and before July 1, so that only
dates in June would be used to sum column (H)? I can't figure out how to
get the formula to use the dates as criteria for a SUMIF function.

Any suggestions would be greatly appreciated.

Thanks,

TDS

=SUMIF(L1:L1000,">="&StartDate,H1:H1000) - SUMIF(L1:L1000,">"&EndDate,H1:H1000)


--ron