Is there a way to do a Find/Replace on a column and insert an “AutoSum” into the empty cells?
I have a huge spread sheet that has a list of sales over the past year. I have sorted them by postal code and separated the sales in a certain postal code with a blank row.
Now what I want to do is total up the sales for each postal code. Problem is, there are hundreds of postal codes and the last time I did this it took me AGES to click on each blank cell and click the AutoSum button.
If I could just select the column that the sales numbers are in, and do a ‘Find/Replace’ for blank cells, (Which would be there the formula would go.) and insert the AutoSum command, it would make my life easier.
But I don’t know what the ‘AutoSum’ command would be apart from the Funky “E” button.
Any one know of a way to do this? (Or something else that will achive the same results?)