| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help? SUM row to a cell with a specific value in a different r
You're quite welcome.
"DIY Guy" wrote: On Feb 6, 11:29 pm, JMB wrote: To throw out some other suggestions that appeared to work okay (if I understand what you're asking): To sum all values in row 5 up to (and including) the midterm, you could try: =Sum(Sheet1!A5:Index(A5:Z5, Match("m", Sheet1!A1:Z1, 0))) To exclude the midterm: =Sum(Sheet1!A5:Index(A5:Z5, Match("m", Sheet1!A1:Z1, 0)-1)) To sum all "assignments" prior to the first midterm, you could try: =SUMIF(A1:INDEX(A1:Z1,MATCH("m",A1:Z1,0)),"a",A5:Z 5) To sum all "quizzes" prior to the first midterm, you could try: =SUMIF(A1:INDEX(A1:Z1,MATCH("m",A1:Z1,0)),"q",A5:Z 5) Thank you both for your suggestions. JMB, your last two suggestions work perfectly!!! It was exactly what I was looking for! I have been working on this for the better part of the day. I have used the SUMIF, and in my search today, I found the MATCH, but I never came across the INDEX. I could have spent weeks or months before I came up with this, if at all. It's magic! Thank you for your wonderful assistance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
| Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Threaded Mode
