What is the formula to count text only when the next cell contain certain value?

M

[email protected]

New member
I created a table in excel where Calum D contain some cells contain Add and the other Remove, but I just want to count the cell that contain Add if the next cell is equal to certain value.
 
Back
Top