selecting data from different sheets

[aamir]

i have a dropdown list with 6 items and same sheets in the file. how can i fetch data ?


For example: A file attendance for 6 months Jan to June. with 7 sheets main sheet and 6 sheets each for each month. on main sheet dropdown list (Jan-June) which would show late, early, ontime etc


COUNTIFS($J$2:$J$500,"Late",$A$2:$A$500,"Joe")

i am unable to link between sheets ..on same sheet everything is working fine.

 

[jeffreybrown]

You would have to use the Indirect function to get the count across all sheets.

IMO, a better method would be to perform a countif on each sheet and then sum across all sheets.

Here's a place to get started.

http://www.mrexcel.com/forum/showthread.php?t=530726

or

http://www.ozgrid.com/forum/showthread.php?t=85646