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