COUNTIF ARRAY FORMULA
Posted by Shazadi on March 01, 2001 12:56 PM
I cannot figure out why this formula keeps giving me a value of 0:
I am trying to count the number of dealers that have reported numbers for both columns. I am hitting the CTRL and SHIFT ENTER for the array and it still isn't working.
Can anyone tell me where I have gone wrong?
Thank you again for your previous help, and I thought I had learned how to do these but apparently I am missing something here.