If & calculation formulas needed

Hi everyone!!

Please see my attached sheet it explains exactly what i need and where i need it.
As the title says i think its IF formulas i need plus there are some calculation i need some involving percentages!!

Thanks in advance i you can help, because its doing my head-in trying to work it out and failing!!!!

Well in G14
=F14*E14
and copy down to the cells below

in e35
=SUMIF($D$14:$D$33,"Awaiting Authorisation",$E$14:$E$33)
just replace the awaiting authorisation with the other text for the cells below

Does that help

REgards

Dav

That works great cheers, easy when you know how!!
One more question i want a total in cell G35 for the total amount in the range G14:G33, do you know the formula i need for this please??

Thanks

Of course it is, thanks for that!! Just me being stupid!!

Thanks again

If this solves your problem please change the initial thread title to " solved" Thx