How do I run a conditional sum formula for an entire worksheet?

[mbresloff]

Hi all,
I have no idea if the title of this thread actually conveys what I'm trying to figure out - please forgive me as I'm a complete newb.

I have a spreadsheet (see link at bottom of post), and I would like to run a script/formula that would add up the figures in column C for each unique property listed in column A. The total would appear in the last row of a property's specific range, like in column D.

The spreadsheet that I need to actually do my work on has hundred's of properties, and many letters for each property. To add this up manually would take hours! Is there a way I can do this quickly and easily?

Hopefully my question makes sense. If there is some formula or script I can run that could do this for me, I would be extremely grateful. Thanks!example.xlsx -- here's the link

[vlady]

Extract the unique properties then sumif

Edit: Forgot attachment
example (14).xlsx

[Pete_UK]

I only have an old version of Excel on this laptop that I'm using, so I can't open your xlsx file. Is the data sorted by column A? If so, you could put this formula in D2 (assuming a row of headers):

=IF(A2=A3,"",SUMIF(A:A,A2,C:C))

then copy down by double-clicking the fill handle - the conditional sum will appear only on the last line of any particular block of data.

Hope this helps.

Pete

[mbresloff]

Thanks so much for your help everyone. I was able to tweak vlady's formula slightly and got it to do what I needed.