Try something like this:
=SUMPRODUCT(--(TEXT($B$1:$B$50,"yyyymm")="198007"))
Does that help?
Regards,
Ron
Try something like this:
=SUMPRODUCT(--(TEXT($B$1:$B$50,"yyyymm")="198007"))
Does that help?
Regards,
Ron
Yes! Perfect! Exactly what I needed. Thanks a bunch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks