index countif

Currently using this formula to sum information from a large workbook. I want to link 5 workbooks so that certain info from workbook 1 will be visible all other workbooks and vice versa. =SUMIF(INDIRECT("'"&$K$9&"'!c$12:c$25"),F$10:F$23,INDIRECT("'"&$K$9&"'!h$12:h$25")) only problem with the...

Hi, sorry about my English.. i need help about this Excel table. i want to know the total available Person of languages.. (Count) is this with index and match function? Please help !!

Hi folks, I've got a (reasonably complicated) issue that I thought I had solved by learning how to use the INDIRECT function, but now I'm being told that my solution is inadequate because people don't like being asked to save changes when they quit if they know they didn't make any changes...

I have a question for all those with more Excel experience than I. We perform thermal cycling here at work and include event detection. The thermal cycles are performed in 100 cycle sessions. The event detection tells us when an electrical part has failed. When a part fails, the programs...

I've found 30 to 40 similar examples on formulas that should solve my problem, but so far none have worked. One thing I have noticed with many of these examples is the requirement to press 'Control + Shift + Enter' for an array formula. I have Excel 2013 and no brackets appear and I'm not sure...

I've been looking for a solution with no success. My workbook has been moved to Google Spreadsheets but for the most part, this should be a non-issue. I created a Google Form that automatically feeds results/data to a tab in my spreadsheet. Each "survey" completed fills a row on the sheet so...