Formula using SUMIF & IF
 

Hi all,

I am using this formula: =IF(B6=A6:A390=B5,SUMIF(F6:F390,
"*8in*",E6:E390))
to:
Sum values in the range E6 to E390 where 8in is found in the
corresponding cells in the range F6:F390 and the values in the range
A6:A390 lie between the values contained in cells B6 and B5

It is not giving me the desired result so obviously there is something
wrong with my formula. Can anyone help me?

(Simply stated I want to sum those values in range e6:e390 if "8in" is
found in the string in range f6:f390 while the corresponding value in
range a6:a390 lies between the boundary conditions in cells b6 & b5)
(Hope I made myself clear.)


Thanks to all.

biggy

Formula using SUMIF & IF
 

One way ..

=SUMPRODUCT((A6:A390B5)*(A6:A390<B6)*ISNUMBER(SEA RCH("8in",F6:F390)),E6:E39
0)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BiggyTwo" wrote in message
ups.com...
Hi all,

I am using this formula: =IF(B6=A6:A390=B5,SUMIF(F6:F390,
"*8in*",E6:E390))
to:
Sum values in the range E6 to E390 where 8in is found in the
corresponding cells in the range F6:F390 and the values in the range
A6:A390 lie between the values contained in cells B6 and B5

It is not giving me the desired result so obviously there is something
wrong with my formula. Can anyone help me?

(Simply stated I want to sum those values in range e6:e390 if "8in" is
found in the string in range f6:f390 while the corresponding value in
range a6:a390 lies between the boundary conditions in cells b6 & b5)
(Hope I made myself clear.)


Thanks to all.

biggy

Formula using SUMIF & IF
 

Oops, slight correction, should be:

=SUMPRODUCT((A6:A390=B5)*(A6:A390<=B6)*ISNUMBER(S EARCH("8in",F6:F390)),E6:E
390)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Formula using SUMIF & IF
 

Thanks Max, just the solution I hoped for. Thanks again.

Biggy