Thank you ahead of time for your responses. I know the following can be done, but I am looking for the right words to use or reference pages to get this done.
It does not let me post an image, but an example:
I have the following: VarA in A1, number for VarA in B1 VarB in A2, number for VarB in B2 VarA in C5, number for VarA in D5 VarB in C6, number for VarB in D6
I am looking for a way to tell excel to "look through every cell on the spreadsheet that is "VarA" -> reference the number to the right of that variable" so I can get a total for the whole sheet for all of the numbers next to VarA.
Any help on this would be greatly appreciated. Thank you for your time.
No comments:
Post a Comment