I want to know if there's a formula for the following--
Basically -- on sheet 2 for the name of an insurance, I want it to take the sum total for the same insurance on sheet 1.
I have 4 agencies I will need to create spreadsheets for. Not all insurances are in every agency. So I'm hoping there's an easy way to have a formula match the contents of the cell instead of having to put in a formula with every single insurance name (there's over 200).
Hope I've explained it well enough. :D
Thanks for any help!
Jen
Bookmarks