I will try to make this easy, and I am sure that the solution of this problem is simple, but I am just not sure.
I need to calculate total value based on "x", the name and "totalt". Meaning, I need to make an formula that works, for example how much Teo has billed in value. The example with Teo would include the numbers: 11550+10500+2100+1485 (I have a lot of rows beneath in my excel sheet).
The question: How do I write a formula for Teo, Erik, Sven etc to calculate those numbers based on the "x" I put in?
Thanks for replies on this matter!
Skjermbilde 2014-09-25 kl. 15.07.49.png