I have a huge excel spreadsheet that I have inherited through an acquisition. 32,000 rows with 10 columns. I would like to count some dollar amounts in column "K" based on a vendor name in column "F and a division name listed in column "E".
For example if I wanted to know how much money, from column "K" had been spent by division 4, in column "E" with vendor "8" in column "F", what formula would I use?
For example if I wanted to know how much money, from column "K" had been spent by division 4, in column "E" with vendor "8" in column "F", what formula would I use?