Good morning all.
Not sure where to look for help on this issue as no matter what I type in to help files, nothing seems to pop up.
I have a statistics page in a file that captures data from 12 data sheets.
I want to be able to look for a value over the entire 12 sheets.
Column D on all 12 sheets have dates.
I would like to return a count if any cell in column D across the 12 sheets has a specific value.
ie .. how many cells have a value of 1 Sept.
Any ideas?
Have tried VLOOKUP and COUNTIF .. but cant seem to get them to work across multiple sheets.
HELP !!