Thread: Is there an equivalent of sumproduct but for count?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default Is there an equivalent of sumproduct but for count?
That should return the COUNT of items "Eatern" and =30. Do you mean SUM, perhaps?

=SUMPRODUCT(('All Divisions'!A2:A3039="Eastern")*
('All Divisions'!J2:J3039=30)*('All Divisions'!J2:J3039))

HTH,
Bernie
MS Excel MVP


"PGarcia" wrote in message
...
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