# Multiple Conditions

1. ## Multiple Conditions

I'm trying to get a formula that will look at 2 separate rows of cells and give me a count that meets certain conditions. In the example row 1 has the type of pet (some multiple) and row 2 uses an "*" to signify that it's on hand. I would want the formula to look at row 1 and if it's a "dog" to then look at row 2 for any "dog" cell that also has an "*". Then do the same for all the other pets. Attached is an example.

Thanks!

2. ## Re: Multiple Conditions

Place this in C:6 =COUNTIFS(B1:L1,"Dog",B2:L2,"*") then in the additional cells replace "Dog" with "Cat" etc.

3. ## Re: Multiple Conditions

Hello,
Try this formula in C6 and copy down.

``Please Login or Register  to view this content.``

4. ## Re: Multiple Conditions

GC, I'm not the original post but, I tried your formula and it places a value of 1 in each of the cells. Did I miss something?

5. ## Re: Multiple Conditions

gmr4evr1- thanks a bunch! It worked just like I needed it to!

6. ## Re: Multiple Conditions

Not a problem, glad it worked for you

7. ## Re: Multiple Conditions

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

8. ## Re: Multiple Conditions

GC, I'm not the original post but, I tried your formula and it places a value of 1 in each of the cells. Did I miss something?
My results are 1 3 1 1

Here's the formula in C7.
``Please Login or Register  to view this content.``
Are you in manual calculation mode ?

9. ## Re: Multiple Conditions

Originally Posted by GC Excel
My results are 1 3 1 1

Here's the formula in C7.
``Please Login or Register  to view this content.``
Are you in manual calculation mode ?
Ok, I see why, when I copied and pasted down the cells, the =\$A6 did not change for the corresponding cell(s)

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1