Hi, what am I doing wrong with the following formula:
=countif(sheet1:sheet31!E6:E35,">=1")
FOR some reason this formula fails when I use the (sheet1:sheet31) with the column range (E6:E35).
Is it possible to include a multiple sheet count and column range in the same Formula? Thanks for any helpful responses..
By the way, the formula works ok just as long as I'm not trying to read multiple sheets.. Please help on this.
This is the formula I had to write for each 30 rows X 31 days because I cant get the (sheet:sheet) to work:
=COUNTIF('4TH'!E6:E35,E6)+COUNTIF('2ND'!E6:E35,E6)+COUNTIF('3RD'!E6:E35,E6)+COUNTIF('5TH'!E6:E35,E6)+COUNTIF('6TH'!E6:E35,E6)+COUNTIF('7TH'!E6:E35,E6)+COUNTIF('8TH'!E6:E35,E6)+COUNTIF('9TH'!E6:E35,E6)+COUNTIF('10TH'!E6:E35,E6)+COUNTIF('11TH'!E6:E35,E6)+COUNTIF('12TH'!E6:E35,E6)+COUNTIF('13TH'!E6:E35,E6)+COUNTIF('14TH'!E6:E35,E6)+COUNTIF('15TH'!E6:E35,E6)+COUNTIF('16TH'!E6:E35,E6)+COUNTIF('17TH'!E6:E35,E6)+COUNTIF('18TH'!E6:E35,E6)+COUNTIF('19TH'!E6:E35,E6)+COUNTIF('20TH'!E6:E35,E6)+COUNTIF('21ST'!E6:E35,E6)+COUNTIF('22ND'!E6:E35,E6)+COUNTIF('23RD'!E6:E35,E6)+COUNTIF('24TH'!E6:E35,E6)+COUNTIF('25TH'!E6:E35,E6)+COUNTIF('26TH'!E6:E35,E6)+COUNTIF('27TH'!E6:E35,E6)+COUNTIF('28TH'!E6:E35,E6)+COUNTIF('29TH'!E6:E35,E6)+COUNTIF('30TH'!E6:E35,E6)+COUNTIF('31ST'!E6:E35,E6)
Bookmarks