HELLO!
I am somewhere between beginner and intermediate in Excel. I'm working on creating an if statement but am not quite sure how to get it just right, as it's a little more complicated than those I've done before.
I have a column containing values such as 24A-24E, and another column containing numerical values. What I am looking to do is if the value in B7:B160 is 24A, I want it to add the number in AV7:AV160 to a different cell that will hold a running total. IF the value in B7:B160 is 24B, add that number to the cell for 24B, etc.
I need to know the total of any line that has 24A as the account, and the total of any line that has 24B as the account, etc. Basically, if B7 is 24A, put the number in AV7 into a cell that holds a sum for each item that is 24A. Not just a count; I need the sum of those cells.
Hopefully that makes sense. TIA for any help!
Bookmarks