Countif doesnt work across multiple sheets (3d way).
Example: countif(sheet1:sheet3!A1,">0") will result in error.
To fix this, List all the sheet names in a range, say H1:H3
Then write this formula =SUMPRODUCT(COUNTIF(INDIRECT("'"&H1:H3&"'!A1"),">0"))
This will work like a charm!!
Regards,
Praveen KVC
6 January 2010
Wednesday, January 6, 2010
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment