Excel Geek Required! Sumif and Autofilter

[Pheebs]

Hey hey HEY!

I need help..

Annnnnd I need help on excel (before any of you lot got in there!)

I have looked up on various google links the below but it just does not make any sense to me and... despite it's not that important... the fact I cannot do it is annoying me so much I now need to do it

I'll simplify it... so what I have is as follows:

Columns of:

(A1)Description - (B1)Client - (C1)Total - (D1)Paid (Yes/No)

Now the columns have been autofiltered so I can look at my clients (say Bill, Sarah and Joe) separately.

Firstly, what I wanted was to be able to add up all monies paid separately and all the monies outstanding separately.

Sooo I did the formula below for all monies paid:

=SUMIF(D2: D10,"Yes",C2:C10)

Annnnd I did the formula below for all monies outstanding:

=SUMIF(D2: D10,"No",C2:C10)

Simple, works a treat (note put a gap between ":" and "D10" on here but not on because if I don't this little fella pops up: ! Heeh!). HOWEVER! I now want to be to select a specific client from my autofilter (say Sarah) and do the above... but I don't know how to do this. If I select Sarah on the autofilter, the above formulas still include the data which isn't shown (ie Bill and Joes figures!).

Now I've read about subtotals and countif etc but I am now just super confused. People keep chucking random numbers in at the beginning of formulas which, I cannot see, has any relevance to the data!

How do I do this people? Can anyone decipher the interweb better than I or perhaps are just whizz kids themselves?

I uploaded the simplified version:

Stoopido Excel Spreadsheet

Thanks peoples x