Spreadsheet question...

[The Great Wallsendo]

NESA has answered many of my obscure questions in the past so I thought I'd give it another go...

I have a quote from a builder that details all the various costs - I have dragged all these costs into a spreadsheet so that I can "play" about with them...

Is there a way I can select/deselect each fixed value field IE with a "tick" or the like in order that I can change the total field based on my selection

As opposed to manually entering/deleting the data to do it

Make sense?

Any help appreciated

[paul.longstaff]

if your getting building work done tony get labour only prices and supply the materials your self.im a brickie tony this cuts your layout,some builders estimates come out like telephone numbers.

[jonny_s]

Tony you can accomplish this using an alternative sum command called sumif

this conditionally sums a column or selection depending upon whether the sum finds a symbol / character in an adjoining cell

For example you could type an x in the next column and the number in the column next to it would be added but those without an x would be ignored.

The formula =SUMIF(F4:F7,"x",E4:E7) would add every number from e4 to e7 if there is an x in the cell to the right.

Hope this is what you meant.

If you give me your email i will send you an example if needed.

Jonny

[The Great Wallsendo]

worked a charm Jonny - cheers

I knew someone would know

[codseeker]

there you go just for you cheap as chips