I wasn't quite sure how to title this, but here is the situation:
I am looking to get D7 on the 'WS' worksheet to look through both column B and C of the 'AJE' worksheet and find anywhere there is the label of the value of A7(from WS!), and then sum the values of column D - column E on AJE! for only those corresponding rows
I then want to carry this down for each cell of column D & E on 'WS'
I'm not sure if this is something I can do with functions, or not. I do know a little VBA (if I have to go that route) but haven't done much within excel: so even how to get started would be great.
Thanks!
Bookmarks