How I can sum several cell with logic test

**Nadeem Ahmed Kh** · 29th July 2009, 11:49 AM

1 A B C D E
2 1 FLUSH (CWS)
3 ITEM SIZE LENGTH UNIT
4 PIPE 65mm 27.1 Rmt
5 50mm 50.6 Rmt
6 40mm 37.9 Rmt
7 2 HWS (SS)
8 PIPE 50mm 14.3 Rmt
9 40mm 42.5 Rmt
10 32mm 37.1 Rmt
11 3 DOM (CWS)
12 PIPE 80mm 25.8 Rmt
13 65mm 46.4 Rmt
14 50mm 37.9 Rmt
15 4 HYD (CWS)
16 PIPE 50mm 16.9 Rmt
17 40mm 59.8 Rmt
18 32mm 37.9 Rmt

Agar mai chahoo ke jaha jaha 65mm (ya 50mm, 40mm) size ke pipe hai un ke length kisi ek cell mai sum ho jaye, formula ke tahat, individually to mai sum kar sakta hu but koi logically formula ke tahat es ko kisi ek hi cell mai tamam 65mm ke pipe ka total aa jaye, to es ka koi formula bata sakta hai logically.

mai aap ka sukarguzar hunga