Hi all,
I have a spreadsheet with 17 sheets, each named data 2016, data 2015... and so on til data 2000. Each sheet has car listings and spec, with car manufacturer in the C column.
I'm trying to compute a COUNTIF formula that counts all cells named 'Volkswagen' in the C column of all 17 sheets combined, but I'm really struggling to get the correct punctuation needed for it to work.
What I have at the moment is as follows: (i've only done 2016 to 2013 for simplicity, the principle is of course the same)
=COUNTIF(INDIRECT("'{2016 ,2015 ,2014 ,2013 }&" data'!C:C"),"VOLKSWAGEN")
I know I could write out a long formula of 17 Countif functions, each for each year, but I'd like to get it condensed to the formula above. Any help would be appreciated. Thanks!
Bookmarks