dear lilsnoop,
the formula for the count of 'color and text' does not seem to be working. pl check the attached sheet - E12 should read '2' as there are 2 cells (like B12) with 'brown' color and text '1' within the range B2:E2 as specified in the formula, but is reading '1' which is wrong. can u pl help?
Bookmarks