Quote:
Originally Posted by xor
In cell B1:
=(A1>=$C$1)*(A1<=$D$1)*(CELL("format";A1)="D1")
copied down to B10 and then =SUM(B1:B10)
|
Thank you for your help. Unfortunately I don't understand much about formulas in Excel, and so I don't think that I can use yours. Please see the image below. The formula would go in one of the blank cells at the bottom of each column.