Formula to count the times two columns have data

[spacec0w]

Hello all, I have what seems like a pretty simple problem. I have been all over the internet and the forum to find a formula that works, but nothing seems to work.

I've attached a small screenshot of what I'm working with

I just want to have a total of times there is both an x in column B and a number in column C. The total here would be two. Any help is much appreciated. Thanks in advance.

Chris

[sweep]

Hi,

Try this?

=SUMPRODUCT((B:B="x")*(ISNUMBER(C:C)))

[spacec0w]

Works like a charm. Seems like I tried a very similar formula and it didn't work... I'm a bit confused but slightly more happy than before. Thanks!

Chris