Formula problem :-(((

[Mimine]

Can someone please help me with this one :

I want my formula to sum all there is in column "F" only if its colum
B=1 and its column C<10000 :

SUM.IF (AND(B2:B43 = 1);(C2:C43<10000); (F2:F43))

What is the right way to write this formula ???

Thanks a lot !!

 

[Bruno Campanini]

Can someone please help me with this one :

I want my formula to sum all there is in column "F" only if its column
B=1 and its column C<10000 :

SUM.IF (AND(B2:B43 = 1);(C2:C43<10000); (F2:F43))

What is the right way to write this formula ???

Thanks a lot !!!

One way:

=SUMPRODUCT(--(B2:B43=1),--(C2:C43<10000),F2:F43)

Bruno

 

[Mimine]

Thank you very much Dominic but
when I try your formula, the answer is "#value".

My B & C columns are formatted in numbers and my F is money...

If you have any other ideas.... Please !

Thanks again !


Mimine

 

[swatsp0p]

Dominicb's formula will work if you enter it as an ARRAY formula. D
this by first pressing F2 and then holding down the CTRL and the SHIF
keys while pressing ENTER. Excel will then place braces around th
formula to indicate it is an Array, as such:

{=SUM(IF($B$2:$B$43=1,IF($C$2:$C$43<10000,$F$2:$F$43,0),0))}

Does this work for you?

Bruc

 

[dominicb]

Whoops!

Thanks for pointing that out Bruce! Bottom of the class for me...

DominicB

 

[swatsp0p]

Not to worry, Dom... been there, done that!

This is a team effort, after all!!

Cheers!

 

[Mimine]

Finally I (you) got it !!!

Thanks (I've been trying to find it for the last 24 hours.....)

Have a great day all !!!


Mimine