How to make IF than SUM formula?

[wc420pro]

I have simple table for entering date and value of fuel receipt for company cars. What I would like to do is to make formula which will automatically SUM all the values in column F for given type of fuel (LPG, PETROL, DIESEL) in column E.

THANK YOU SO MUCH

Fuel.xlsx

[Speshul]

Change the values in column E from

TOTAL/gas
TOTAL/petrol
TOTAL/disel

to

gas
petrol
disel


and use this formula in F14, copy down
=SUMIF($E$3:$E$11,E14,$F$3:$F$11)
You can type Total into D14, D15, and D16 if you need to display the word TOTAL

[TMS]

F14:

Please Login or Register  to view this content.

and copy down.


Regards, TMS

[wc420pro]

Guys thank you so much. But it doesn't work
I have tried both solutions and I am getting error

Screenshot 2014-10-21 22.16.42.jpg

[wc420pro]

Guys :-) I have made it!!!!

THANK YOU!!!!!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.