Hi,
Does somebody knows a formula for this?
year sold price
2004 305 11.56
2006 75 9.8
2007 98 10.9
2004 197 4.5
2005 256 15
2006 48 7.6
2004 310 18.9
Now I need the total amount for 2004 in one cell eg (305*11.56+197*4.5+310*18.9) so which formula can I use for this?
Thanks in advantage.
Bookmarks