Sheet Summary - Countif - #Invalid Operation

JDen

Hi all,

Ok I am going crazy, hope someone can tell me where I am going wrong:

• I keep getting #Invalid Operation on a sheet summary Countif Formual based column "Days to Obtain PO Range" - This column had a formula in it
• I have a second column called "Test" - this column has the same formula as the above

Why am I getting a result for the TEST column and getting a #Invalid Operation for the "Days to Obtain PO Range" column? The only difference is the longer name of the first column.

Paul Newcome

Do you have that error anywhere within the range you are evaluating?

Paul Newcome

Do you have that error anywhere within the range you are evaluating?