Results 1 to 3 of 3
2001-01-06, 12:39 #1dallasfanGuest
I want to use something like COUNTIF, but I need to be able to check 2 non-consecutive columns for specific values. For instance, I need to check a range of cells in column A for the value 20 and column F for the value 10. When both are true, then count it. I am thinking there is a way to use an Array Function along with a "double" COUNTIF. I just can't figure it out. Any ideas?
2001-01-06, 13:06 #2
- Join Date
- Dec 2000
- Thanked 0 Times in 0 Posts
This is an array formula and must be entered using Control+Shift+Enter
2001-01-08, 11:39 #3dallasfanGuest
Thank you, Thank you, Thank you !!!
I knew it was possible, but I just couldn't remember how.