I am trying to configure a function that will automatically do this:

If value in cell D3=P, then insert the value in cell C3 into cell G3. I want
to insert this function all the way down column G, so that I have a new
column listing values labelled by me as "P" (see next note), which I will
then apply a "sum" function to.

Column C has a dollar value, D lists W for "work" and P for "personal". I
want all personal values added up independantly and automatically from all
work values (having one cell for each running total).

There might be an easier way to do this; I am not familiar with the concept
of names. I have trouble understanding the MS help wording, I need a MS help
dictionary!

I have tried to do several other things along this line, if A1=#, then put
C4 in G6, etc. etc. The only conditional function I know how to type is
IF(ISERROR...).

Please help! Thank you!