Thread: Is there an equivalent of sumproduct but for count?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
  
Posts: 304
Default Is there an equivalent of sumproduct but for count?
I have the following formla, but am look to do the same with "count". Thanks

=SUMPRODUCT(--('All Divisions'!A2:A3039="Eastern"),--('All
Divisions'!J2:J3039=30))
Reply With QuoteReply With Quote