General discussion
October 8, 2003 at 03:45 AM
raymond.hale

Testing value of 2 cells in COUNTIF()

by raymond.hale . Updated 22 years, 11 months ago

Is there a way to test for values in two different cells of a row when using COUNTIF() in a column? In other words,something like COUNTIF ((b3=”x”) AND (b4=3)). I would also like to know how to test a cell for the color fill pattern and count it if it is a certain fill color.

This discussion is locked

All Comments