Adding total dollars based on specific data from another column

G

Guest

I have a cell I'm trying to calculate the total dollars based on specific
criteria from a column of data. Example, column A has 25 cells with data
like A, B, C, D, E, F, and a second column with dollar amounts associated
with each of these outcomes, i.e. A=$5, B=$2, C=$9 etc. I want to create a
formula in a different cell that tells me "if cell = A for $5 then what is
the total dollar amount. A "if then" scenario....Any help????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing two columns of different data 4
Another sumproduct question 3
Update total based on two columns 1
Sum is not correct after adding calculated fields 4
Sum Totaled based on Matching Identical Criteria in Worksheet 1
Sum a range based on a column 2
Cell not calculating after importing data 2
Formula with multiple critera 2

Top