Need help with a problem.

  • Thread starter Thread starter Tom Snuggs
  • Start date Start date
T

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
 
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
 
Tom,

Try
=SUMPRODUCT((L1:L20>DATE(2003,5,30))*(L1:L20<DATE(2003,7,1))*(H1:H20))
 
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
Click to expand...

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


--ron
 
Back
Top