Originally Posted by
emanon132501
Try this formula, it is entered as an array formula (ctrl+shift+enter).
=SUM(IF($A$1:$A$15>=D3,IF($A$1:$A$15<=EOMONTH(D3,0),1,0),0))
2 points (other than the solution offered already works)
a) a CSE array is regarded as slower than a Sumproduct
b) EOMONTH requires AnalysisToolPak be activated - please always be sure to inform OP of this if using ATP function.
EDIT - 3 points...
3rd point... if you insisted on using a CSE array could simplify somewhat to:
The * will coerce the Booleans, such that TRUE * TRUE = 1 ... no need for IF approach in this instance.
Bookmarks