Mgiyuk

Calculate cell only when column header equals a certain value First time poster so any would be greatly appreciated. I would like to perform calculations on a given row only when the column header contains a value. Column A **Name** Column B **Test 1** Column C **H1** Column D **H2** Column E **Test 2** The above example will better explain what I'd like to do. I have a series of columns, some with test results and with homework results. Tests and Homework results can be in any order. What I would like to do is perform calculations such average, sum etc based on whether it is a homework or test. So that for example I would like to average all the homework results for a pupil (on a given row). Is this possible and if so how. I am using Excel 2010 if that helps. Maybe an example with figures will help describe your problem? – Jerry Oct 7 '13 at 8:56 ...

Create a table using only specific columns in google spreadsheet or excel Concept of what I'd like to do Please checkout above image before reading this, So I want to create a table in which I want [X] columns, and based on length of rows it would search for specified values that will be found in columns and then make entries in rows.I've tried to explain it using the image. I hope it's clear enough. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.