|
Counting Dates - Not Text
Hi Biff,
I'm sorry but it dit not work. I come up with a zero (0). "Biff" wrote: Try it like this: =SUMPRODUCT(--(ISNUMBER(DATE!J2:J1116)),--(TEXT(DATE!J2:J1116,"m")="1")) -- Biff Miscrosoft Excel MVP "Danny" wrote: Hi, I'm trying to count the number of "date" occurrences on a particular month. However in the same column, aside from dates, there are TEXT entries and blank cells. When I use the formula below it gives me a #VALUE! Please edit the formula below so I can count the number of date occurences. =SUMPRODUCT(--(MONTH('Date'!J2:J1116)=1)) Thank you. |
Counting Dates - Not Text
It worked perfectly. Thanks a lot!
"Toppers" wrote: try: =SUMPRODUCT(--(TEXT(Date!J2:J1116,"m")="1"),--(Date!J2:J1116<"")) "Danny" wrote: Hi Biff, I'm sorry but it dit not work. I come up with a zero (0). "Biff" wrote: Try it like this: =SUMPRODUCT(--(ISNUMBER(DATE!J2:J1116)),--(TEXT(DATE!J2:J1116,"m")="1")) -- Biff Miscrosoft Excel MVP "Danny" wrote: Hi, I'm trying to count the number of "date" occurrences on a particular month. However in the same column, aside from dates, there are TEXT entries and blank cells. When I use the formula below it gives me a #VALUE! Please edit the formula below so I can count the number of date occurences. =SUMPRODUCT(--(MONTH('Date'!J2:J1116)=1)) Thank you. |
| All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com