On Nov 4, 9:17*am, ibvalentine
wrote:
I am counting the number of "Yes" answers on each worksheet of a workbook..
All the yes answers on in cell B2 of each sheet. The only way I could come up
with to accomplish it is as follows:

=COUNTIF('Resize Row'!B2, "=Yes") + COUNTIF('Copy Formatting'!B2, "=Yes") +
COUNTIF('Formatting Cells'!B2, "=Yes") + COUNTIF('Basic Chart'!B2, "=Yes") +
COUNTIF('Modify Chart'!B2, "=Yes") + COUNTIF('Sorting Data'!B2, "=Yes") +
COUNTIF('Filtering Data'!B2, "=Yes") + COUNTIF('Printing Data'!B2, "=Yes") +
COUNTIF('Find and Replace'!B2, "=Yes") + COUNTIF(AutoFill!B2, "=Yes") +
COUNTIF(Comments!B2, "=Yes") + COUNTIF('Number Formatting'!B2, "=Yes")

I am using v. 2003 so I cannot use the new COUNTIFS function. This works but
it is rather time consuming and long (I have to add 35 sheets at the end)..
Does anyone know of a better way without resorting to VBA?

Thanks.

Use =IF(B2="Yes",1,0) in the same free cell on each of your sheets, eg
C2, then use...

=SUM('Resize Row:Number Formatting'!C2)

I have assumed that with the above sheets Resize Row Sheet's tab is
the left-most tab and Number Formatting Sheet's tab is the right-most
tab.

Ken Johnson

Ken Johnson