I'm not totally sure that it's possible to do this but, I can't find anything specific that tells me how.
I want to create a running total on a separate worksheet that will sum the numbers from certains cells only if a string in a cell is equal to it.
For example:
Sheet 1
A1 A5
0101 $10.00
0102 $12.00
0103 $13.00
0101 $15.00
So on the total sheet I would want it to recognize the A1 strings and then run a total of all of A5's even if I were to all new numbers to the total.
For example:
Sheet 2
A1 A5
0101 $25.00
0102 $12.00
0103 $13.00
Sorry if I'm not being clear, I'm trying my best explain what I'm trying to do.
Bookmarks