Thread: Need to Count the number of times a value occurs within a dt range
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Need to Count the number of times a value occurs within a dt r
Some comments:
=SUM(IF(Data!$A$2:$A$2000=A4,IF(Data!$A$2:$A$92<B 4,Data!$F$2:$F$92,0),0))

1. The ranges need to be identically sized
2. You need to press CTRL+SHIFT+ENTER to confirm the formula

Try this alternative, normal ENTER will do:
=SUMPRODUCT((Data!A$2:A$2000=A4)*(Data!A$2:A$2000 <B4)*(Data!D$2:D$2000="Recordable")*Data!F$2:F$200 0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote