D
davegb
I'm trying to count then occurences of "C" in the same column on 13
different worksheets (same workbook) named Q1 to Q13. I did a countif
on each sheet, then entered the following formula in a summary sheet:
=sum(Q1:Q13!C65)
I'm getting a #VALUE error because XL keeps inserting single quotes
into my formula so it becomes
=sum(Q1:'Q13'!C65)
Does anyone know why XL is editing my forumla this way? Is there a
workaround?
Thanks.
different worksheets (same workbook) named Q1 to Q13. I did a countif
on each sheet, then entered the following formula in a summary sheet:
=sum(Q1:Q13!C65)
I'm getting a #VALUE error because XL keeps inserting single quotes
into my formula so it becomes
=sum(Q1:'Q13'!C65)
Does anyone know why XL is editing my forumla this way? Is there a
workaround?
Thanks.