Most valuable professional
  • Hot Topics

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

In the worksheet below, I need the count and dollar value totals of lines in Column B that are the same as or earlier than Column A to be reported in E2 and F2. I tried with various attempts at COUNTIF but failed. I'm not an Excel expert - Intermediate at best. NOTE: There will be blank cells as there are in this table, though they may not always be sorted to the bottom of the list as they are here. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 28, 2016.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel