Hi. I'm doing an excel challenge for a prospective job and I need help with the last 2 problems. The answers have to come in the form of a formula.
The first is a formula that counts the appearances of a specific month (June). The dates are listed in column E (range E2:E252) and are in the m/dd/yyyy format.
The second problem is more challenging and I will post it after I solve the first one with your help.
Thank you in advance.
try using this
=SUMPRODUCT((MONTH(E2:E252)=6)*1)
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
THANKS! I knew it was a combination of SUMPRODUCT and MONTH. What does the "*1" represent if you don't mind me asking?
I'm going to work on the last problem and if I get stumped (high probability) I'll post it here.
the first portion MONTH(E2:E252)=6 returns a TRUE or FALSE value into the array, you then multiply by 1 to get a numeric value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks