Morning Gents,
I have a sheet with 3 named ranges, I want (on a separate sheet) a cell which counts all occurrences of the word "Bank Holiday" within all three named ranges. I have attempted to use the following:- (AAPR1, AAPR2, AAPR3 are the named ranges)
=COUNTIFS(AAPR1,"Bank Holiday",AAPR2,"Bank Holiday",AAPR3,"Bank Holiday")
There is no error reported when the above is entered but likewise is returning no values. I don't know if it makes any difference but the word "Bank Holiday" is selected from a data validation list, I dont see why it would make a difference as when i just use =COUNTIF(AAPR1,"Bank Holiday") it returns a value.
Thank you for your help.
I have a sheet with 3 named ranges, I want (on a separate sheet) a cell which counts all occurrences of the word "Bank Holiday" within all three named ranges. I have attempted to use the following:- (AAPR1, AAPR2, AAPR3 are the named ranges)
=COUNTIFS(AAPR1,"Bank Holiday",AAPR2,"Bank Holiday",AAPR3,"Bank Holiday")
There is no error reported when the above is entered but likewise is returning no values. I don't know if it makes any difference but the word "Bank Holiday" is selected from a data validation list, I dont see why it would make a difference as when i just use =COUNTIF(AAPR1,"Bank Holiday") it returns a value.
Thank you for your help.