Formula problem :-(((

  • Thread starter Thread starter Mimine
  • Start date Start date
M

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 !!
 
Mimine said:
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 !!!
Click to expand...

One way:

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

Bruno
 
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
 
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
 
Finally I (you) got it !!!

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

Have a great day all !!!


Mimine
 
Back
Top