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:
- Microsoft Excel