Is there an equivalent of sumproduct but for count?
Thanks, but that gave me 41964 and it should have returned 395.
I was looking to get how many €śEastern€ť that are over 30 days old there are,
e.g. 3 or 25 day over 30. The formula provided adds up the days that are
there, e.g. 31 days, 45 days, 76 days, 103 days = 255
Tnanks.
"Bernie Deitrick" wrote:
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))
|