DisplayName
New Member
- Joined
- May 24, 2017
- Messages
- 10
Hello - I'm an Excel novice, and need help constructing an index match formula using 2 rows. I have 2 subtotal rows that I want to add if the date matches whatever month I set it too.
Right now I have this formula to return the current months total. I want the formula to look at 2 rows & add them, and return the current months total.
=INDEX($X$64:$AI$64,MATCH($AP$3,$X$7:$AI$7,0))
=index(operating exp row,match(MONTH,jul-jun row,0))
Hope this makes sense!
Right now I have this formula to return the current months total. I want the formula to look at 2 rows & add them, and return the current months total.
=INDEX($X$64:$AI$64,MATCH($AP$3,$X$7:$AI$7,0))
=index(operating exp row,match(MONTH,jul-jun row,0))
Hope this makes sense!