Good Day Everyone!
I'm hoping someone could help me figure out how to accomplish the following in Excel 2010:
- I have a workbook with 16 sheets (one for each year 1997-2012) containing data on individual files. The individual file information is input horizontally (with date in column 'A', name in column 'B' company number in column 'C' and so on...)
- There are a different number of files for each year (1997 has 4, 2010 has 30)
- On sheet 17 I have put the data analysis
- I am looking for a formula that will tell me how many times 'tbd' appears in the worksheet 1997 where the company number in the same row is '1'. Put another way, on sheet 1997 how many 'tbd's (to be determined) are there for company number 1?
I have tried countifs and sumproduct etc. but nothing seems to work correctly. I am hoping there is a formula someone might know of that will search through entire columns as opposed to having to name a specific range (ie search C:C instead of C4:C10).
If anyone is able to provide assistance it would be greatly appreciated!!