Countif formula query for multiple worksheets.

[vaidmohammed]

I am having an excel sheet with Index.

INDEX Pass Failed
Order Entry 50 60
Report 70 80

The workbook contains functionality wise test cases in different sheets. The Index contains the name of the Worksheets and also haves the counts of test cases in the respective sheets.

I have made following formula to count the status of test cases from different sheets in Index sheet.

=COUNTIF('Order Entry'!"F4:F250,"Pass")

I need a formula whereby instead of giving the name of the sheet as "Order Entry" I just give the reference of cell which contains the name of the sheet and applications works out as working for the above formula.

 

[Sam Mathai Chacko]

Try this

=COUNTIF(INDIRECT("'"&A1&"'!F4:F250"),"Pass") where A1 has the name of the sheet

 

[vaidmohammed]

SUPERB Sam!!!! Hats Off.... You have solved my problem.... loving it....