Thank you. Will try it.
The double minus (as in "--") is new to me. What does it do?
GBExcel
T. Valko wrote:
Try this...
=SUMPRODUCT(--(TEXT(AP59:AP2000,"mmyyyy")=BA58),AR59:AR2000)
Will the date in cell BA58 appear *only once* in the range AP59:AP2000?
Yes, that is correct.
GBExcel
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/201001/1