Thread: Need to Count the number of times a value occurs within a dt range
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gina[_2_] Gina[_2_] is offline
external usenet poster
  
Posts: 49
Default Need to Count the number of times a value occurs within a dt r
Thank you. That did work exactly as I hoped it would.
Gina

"Max" wrote:

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 QuoteReply With Quote