Hi,
I'm looking for two formulas if possible.
The formulas need to look up column headers and return results for rows that meet the variable criteria specified.
Cell K16 returns the count for rows that meet all the criteria given in J8:K15.
Cell K19 returns the average for the cells in the column detailed in K18 for the rows identified in the the criteria given in J8:K15.
Please note that the data B4:H25 will have gaps (data missing) so these rows need to be ignored if they are not complete and the criteria in J8:K15 will vary in number of entries.
I'm really looking for a formula solution (not vba) in this instance if possible.
I cannot see how to attached the file so I have given the screenshot only.
Any help much appreciated.
I'm looking for two formulas if possible.
The formulas need to look up column headers and return results for rows that meet the variable criteria specified.
Cell K16 returns the count for rows that meet all the criteria given in J8:K15.
Cell K19 returns the average for the cells in the column detailed in K18 for the rows identified in the the criteria given in J8:K15.
Please note that the data B4:H25 will have gaps (data missing) so these rows need to be ignored if they are not complete and the criteria in J8:K15 will vary in number of entries.
I'm really looking for a formula solution (not vba) in this instance if possible.
I cannot see how to attached the file so I have given the screenshot only.
Any help much appreciated.