Please help
Column A - dates,
Column B - A,B or C
How many times in Jan 2010 does A, B or C show up...
Dates could go from 2000 to 2020...and all the days that could be in between, but I just want to count the incidences per month of A, B or C
mrsmithexcels
mrsmithexcels,
Detach/open workbook mrsmithexcels - EF740997 - SDG10.xls and see the SUMPRODUCT formulae in H3:J3 copied down.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
See the link to understand SumProduct:
http://www.lqnet.com/Excel/sumproduct.aspx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks