Sumif

[krisso]

I am trying to work out a sumif, or at least thats what i think it should be. The fomula i need to achieve is

"sumif a1 is greater than b1 but less than c1 then F1*F2"
I have tried all different sorts of combinations of the above but cant work it out. Can anyone help me with this.


Regards

Chris

 

[jasonb75]

Try

=IF(AND(A1>B1,A1<C1),F1*F2,"")

You didn't say what the result should be if the criteria is not met so I've assumed leave the cell blank.

Hope this helps.

 

[krisso]

jason,

Thanks for the reply but i cant see your formula properly

Regards

Chris

 

[jasonb75]

Oops, sorry Chris, I forgot to tag it.

=IF(AND(A1>B1,A1<C1),F1*F2,"")

 

[krisso]

Cheers Jason