Counting dates in one column that are earlier than another column summing their dollar values

[Nebulous]

I think the screenshot below adequately describes what I need. I tried with various attempts at CountIF but failed. I'm not expert - Intermediate at best.

I need the count and dollar value totals of lines in Column B that are the same as or earlier than Column A. Can this be done with formulas in E2 and F2?

NOTE: There will be blanks as there are in this image, though they may not always be sorted to the bottom of the list as they are here.


-- removed inline image ---


Thanks!

~N

 

[CyrusTheVirus]

I think the screenshot below adequately describes what I need.

I'm not sure about that.

 

[Nebulous]

Hmmm.... As you can see, I attempted to paste a screenshot and got crud. Isn't it possible to include an image (not one with a URL) in context here? If you can advise me, I'll delete this post and recreate it properly. Please help.

Thanks!

~N

 

[CyrusTheVirus]

you could just copy/paste a sample of your data from excel into your reply and explain what you're trying to accomplish.

 

[Nebulous]

Thanks. I created a new thread with the same name as this one and used a table. Here's the link:
http://www.mrexcel.com/forum/excel-...other-column-summing-their-dollar-values.html

I thought I could delete my own posts but it doesn't appear that I can. I hate to have multiples out there with the same title - looks suspicious