Here's another one...
=SUMPRODUCT(--(TEXT(B$2:B$133,"mmm")=TEXT(D2*29,"mmm")))
Here's another one...
=SUMPRODUCT(--(TEXT(B$2:B$133,"mmm")=TEXT(D2*29,"mmm")))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks