I would like to count the number of times that a numerical value occurs within a range of cells.
I have been able to do this by creating the following formula, which counts the number of times a value is lower than 10:
=COUNTIF(A1:A50,"<"&10)
This works fine, however I would like to go one step further and only apply the above formula if the number appears in a cell that is on the same row as another cell with a particular value.
For example, I only want to know how many times a value lower than 10 appears in column A, if the corresponding value in column B is 'Stage 1'.
It looks like I'll need to nest a COUNTIF function within an IF function, but I could be wrong.
Any help would be greatly appreciated.
Thanks in advance
Shaun
Bookmarks