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!
Bookmarks