Newbie81 via OfficeKB.com

Guest
##
RE: Creating a summary Page

The trouble is that there is a third argument to the formula i need to add in

and that is the depth range.

The average depth of each pipe is calculated and needs to be summarised not

only in size of pipe but also by the depth range it falls into. I need it to

look something like this:

Depth Ranges

Size of pipe 1.0 - 1.5 1.5 - 2.0 2.0 - 2.5

150 Length? Length? Length?

200 Length? Length? Length?

I have tried various formulas the one below is the best so far. Trouble is it

picks up all of the lengths at every depth range

{=SUM(IF(('Foul runs'!$E$6:$E$100>1)+('Foul runs'!$E$6:$E$100<1.5),'Foul

runs'!U$6:U$100))}

On the foul runs page i have got it to split out the various sizes into

different columns using an 'IF' formula ( Would be better if i could

incorperate this in the summary formula). So basically i need to add an

argument that says If the pipe is deeper then 1 but not deeper then 1.5 then

sum the length.

Can you help?

Thanks Grant

Stefan wrote:

>Grant,

>

>If i understand your question right, is your problem that you have several

>lenght's of pipe's. And you want to know what the total size is of the used

>pipes per pipe size.

>

>I think that you can resolve this by using the formula (a) sumif() or (b)

>countif() and multiply this with the size per pipe.

>

>Example (a)

>=Sumif(Range where you see the used size;the size u want to summarize;range

>which can summarize)

>

>Example (b)

>=Countif(Range where you see the used size;the size u want to

>summarize;range which can summarize)*1,50 or b1, etc

>

>Good luck and if this doesn't solve your problem I'll read it here.

>

>Greetings

>

>Stefan

>

>> I am a surveyor and am currently working out quantities of pipework etc.

>>

>[quoted text clipped - 14 lines]

>> Thankyou

>> Grant

--

Message posted via OfficeKB.com

http://www.officekb.com/Uwe/Forums.a...excel/200601/1

## Bookmarks