Thread
:
Need to Count the number of times a value occurs within a dt range
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Max
external usenet poster
Posts: 9,221
Need to Count the number of times a value occurs within a dt r
Correction, it should read ..
Try this alternative, normal ENTER will do:
=SUMPRODUCT((Data!A$2:A$2000=A4)*(Data!A$2:A$2000 <B4)*Data!F$2:F$2000)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With Quote
Max
View Public Profile
Find all posts by Max