Formula help

[robswayne]

Morning Everyone,

first post on here, I am after some help with a formula.

I am setting up a cost sheet and I want a contingency for 5 different area codes. if a cost is added after a line break that cost will be subtracted from the relevant contingency area code.

I hope that make sense? picture added to hopefully help

Thanks Rob

 

[etaf]

what will be entered into the 4 columns - anythign you could use in a SUMIFS() to pull out costs ?

 

[robswayne]

nothing that will be generic. the code column will have 1 of 5 codes in it.

I don't think I have explained it very well. the contingency at the bottom needs to subtract any values that have the same code in. for example if I added in a line for code 1 with a value of £5000 the code 1 contingency would read £45000.

Thanks

 

[etaf]

sorry i'm not following at all now

code1 has an item qty of 5 , so i assume at a cost of each item 10k as shown planned and then a total of 50k (10k * 5)

at the bottom code 1 - 1 item cost 50k, and total 50k

so where is the entry for subtraction of 5k code 1

is that a range inbetween

or just after an empty row

sorry, read a few times

 

[Cubist]

Here's the template for code 1. Repeat for other codes.

=Plan Total Code 1 - SUMIF(Area Code, Code 1, Value)

 

[robswayne]

thank you