COUNTIF function? Or something else?

Hi there! I need help figuring out how to use the countif function or another function for this case.

I have a spreadsheet with a lot of number data in columns B-G. I want Excel to tell me how many times there is a number greater than 0 in BOTH columns C and G. How do I do this? I've tried using countif and can't figure it out. I've also tried googling and no one seems to talk about this. Is there a formula I can use for this?

Also, is there a way to set up multipliers in Excel? So for example, I have a total column. If the total is 12 or less, enter 1. If the total is 12-24, enter 2. And so on by multiples of 12?

Thank you!

Hi Tony,

Thanks so much. The countifs worked!

In regards to the 12 question, 12 would be 1. So I should have said if the number is 21 or less, it would be 1. If it was 13-24, it would be 2. 25-36, would be 3. So on and so forth in multiples of 12.

Thanks Tony! The multiplier worked!