I would like some help with the following count formula based on cells meeting a certain criteria/ condition
Count cells F4:F200 which contain RS but only if cells A4:A200=Jan09 and cells m4:m200=blank
so basically I need to count the number of times where RS appears in cells
F4:F200 based on the other cells meeting the criteria as specified above
Cells f4:f200 could also contain other initials or be blank so must only count where RS appears
Thanks
Try:
=Sumproduct((F4:F200="RS")*(A4:A200="Jan09")*(M4:M200=""))
If A4:A200 are actual date entries formatted as mmmyy then try
=Sumproduct((F4:F200="RS")*(Text(A4:A200,"mmmyy")="Jan09")*(M4:M200=""))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks