Nested COUNTIF

[overmyhead]

I am trying to use a countif with other qualifying variables frm other columns in the same row.

I want to get a count of non numberical data in 2 colums if both conditions are met.

I would like to make this happen:

Please Login or Register  to view this content.

Do not count if the data in A is not an X. X is the actual data, not a placeholder.

I tried SumProduct and SumIf, and Count(If...) but I am missing something someplace.

Anyhelp is appreciated.

[Leith Ross]

Hello overmyhead,

Welcome to the Forum! This group has features to make your code easier to read, and understand. The one feature we require all members to use when posting is placing the code inside a code window. I'll do this for you since you just joined. All other posts will be your responsibility.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line. If you fail to do this next time, your post will be locked until you contact me by private message.

Please read the Forum rules by clicking on the link below...
Forum Rules

Sincerely,
Leith Ross

[VBA Noob]

Maybe

=SUMPRODUCT(--(A1:A100="X")*(C1:C100="Yes"))

VBA Noob

[overmyhead]

Thansk Noob-

That workedperfectly. Does it work with variable text to. If I had a string of data in the second column, and I calculat bsaed on a specific term or symbol?

Please Login or Register  to view this content.

Where the & symbol is what is being searched for?

Thanks again-

[daddylonglegs]

No, you can't use wildcards like that, try

=SUMPRODUCT((A1:A100="X")*ISNUMBER(SEARCH("&", C1:C100)))

[overmyhead]

Perfect.

Thanks so much. I still don't understand how sumproduct works, but it did the trick.

Thank you again.