Here's what I'm trying to say:
If column A is greater than 0, then sum column J if J is greater than
0.
My data download is generally 500-700 rows, so I'm using 1000 to
capture all data. However, my data has repeating headers with text and
Excel seems to treat that as greater than 0 also.
I do have a unique date range field in column E that I can use (in
MM/DD/YYYY format) to say if it's greater than 01/01/1900 , but I
couldn't get that to work either.
Any help would be appreciated.
Thanks,
Phillycheese5
--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile:
http://www.excelforum.com/member.php...o&userid=24196
View this thread:
http://www.excelforum.com/showthread...hreadid=388045