I don't understand IF!

I'm putting together a spreadsheet and one part lists my customers, their value and their current status - 100% / 95% / 85% / 10%

I want to add 4 rows which will only list the customers value at each stage - ie row 1 will only include 100% / row 2 only 95% / row 3 only 85% and row 4 only 10%

I want it to look like this -

100% £15000
95% £8000
85% £6000
10% £12500


I will manually update the status and want the rows to automatically change....

I hope that makes sense!

Thanks very much

Upload a sample workbook with out any confidential data showing u r requirement manually .

Punnam

Hopefully this has attached....

Hi,

Please try the following formula in B36 and drag down.

=SUMPRODUCT(--($G$11:$G$29=$A36),($B$11:$B$29))

Alternatively in B36 and drag down,

=SUMIF($G$11:$G$29,$A36,$B$11:$B$29)

Excellent that worked. Thank you so much!

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, I would like to inform you that you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.