Hi,
I'm currently trying to figure out a way to sum a column of cells that begin with a common sequence of numbers. Is there a formula I can put in to automatically congregate all the cells in the left hand column based on their first 3 digits and sum their corresponding totals in the right hand column?
For example, something like =if(columnA="850...",sum(columnB),"")??
Thanks in advance.
Status DENIED
Row Labels Count of Dealer
3258 1
84309 1
84532 1
85029 1
85048 1
85064 1
85091 1
85436 1
85437 1
85511 1
85512 1
85540 1
86436 1
93129 1
93246 1
93378 1
93493 1
93567 1
93710 1
94086 1
94180 4
Bookmarks