Hi
I would be very grateful if someone could help with with the following problem.
if you look at the attachment, I need to have a countif formula in cell f4. The formula will need to 'if the contents of cell f2 exists in the range of data from A3 to B15, then count the number of times that 0 occurs in column B... So in this instance the value returned would be 3. Then you you typed 'yellow' into cell f2 the result would change to 2.
I hope this makes sense I haven't described it brilliantly.
Bookmarks