Thanks for all your help so far i was very suprised at how quick and the
number of responses (as this is my first post) but i am having a bit of
trouble converting the that formula into my example
here is my actual formula at the moment
=COUNTIF('AU05-02'!D16,"X")+COUNTIF('AU05-09'!D16,"X")+COUNTIF('AU05-12'!D16,"X")+COUNTIF('AU05-14'!D16,"X")+COUNTIF('AU05-23'!D16,"X")+COUNTIF('AU04-24'!D16,"X")+COUNTIF('AU05-29'!D16,"X")+COUNTIF('AU05-34'!D16,"X")+COUNTIF('AU05-36&7'!D16,"X")+COUNTIF('AU05-46'!D16,"X")+COUNTIF('AU05-50'!D16,"X")+COUNTIF('AU05-58'!D16,"X")+COUNTIF('AU05-60'!D16,"X")+COUNTIF('AU05-61'!D16,"X")+COUNTIF('AU05-68'!D16,"X")
Here is a picture that might help you to understand what i would like
to be done.
4642
this survey is on every one of the 16 worksheets but the first
worksheet (Summary 2004_5) is blank and i would like a summary of all
the "X" on all the other worksheets.
Any more help would be greatly appreciated
Thanks
Kieran
+-------------------------------------------------------------------+
|Filename: excelexample.jpg |
|Download:
http://www.excelforum.com/attachment.php?postid=4642 |
+-------------------------------------------------------------------+
--
kmh987
------------------------------------------------------------------------
kmh987's Profile:
http://www.excelforum.com/member.php...o&userid=33533
View this thread:
http://www.excelforum.com/showthread...hreadid=533240