Discussion Locked

Testing value of 2 cells in COUNTIF()

0 helpful

2 replies

by raymond.hale Oct 8, 2003 last reply Oct 8, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by dklippert Oct 8, 2003

The layout of your first question is a little vague. COUNTIF does not handle Boolean operators, but you could count all the x's and then add the count for 3's.
If you're testing for the co-existence of two values, you may want an array formula.
Chip Pearson has covered this quite well at:

http://www.cpearson.com/excel/array.htm

He also discusses count by color, which requires a tiny bit of VBA:

http://www.cpearson.com/excel/colors.htm

by it_cowboy Oct 8, 2003

You can concatenate the two values then look for the value they create when they are joined together with the COUNTIF function.

For Example: In B5, create a formula "=B3&B4" which will produce "X3". Then create COUNTIF("Row 5 range","X3").

This discussion is closed to new replies.

2 replies

Trending Software posts

Icons, favicons and merch graphics on Squarespace: my workflow for getting

How Are Teams Testing AI-Generated Code Before Production?

Can I Print Emails Directly from a PST File

Is CRM software becoming too complicated for small businesses

Is There any Reverse Video Search Tool