need help with sumif function
 

i need some guidance in make a cell formula

some what like this is the formula i need but not sure how to make it
if b3 is less than 25, and b5 = to 3, then add cell b15 and b16

i hope i explained it correctly cause i am at a loss for how to do it

thanks for any replies

need help with sumif function
 

=IF(AND(B3<25,B5=3),B15+B16,"")
--
Gary''s Student - gsnu2007j

need help with sumif function
 

Maybe this:

=IF(AND(B3<25,B5=3),B15+B16,"DesiredFalseResult")

Regards,
Paul

--

"dtminf" wrote in message
...
i need some guidance in make a cell formula

some what like this is the formula i need but not sure how to make it
if b3 is less than 25, and b5 = to 3, then add cell b15 and b16

i hope i explained it correctly cause i am at a loss for how to do it

thanks for any replies

need help with sumif function
 

both of the above worked now I am trying to include mutiple ifs.

basicily it is a calculation sheet in which you enter

quanitities in b3 #1-1000
then total colors in b5 #1-6
then the ending result is based upon
fixed value in b16 thru i23 which is in conjunction with the value in b3

plus another fixed value in b18-b23 with these cost being in conjunction
with b5

I have a link for a pdf below to help.
www.aaufl.com/customart/pricecalculations.pdf

the blue cell determines the horizontal scale the you add the total costs
for the green cells which is determined by the vertical scale which wala
give you your total in the red cell.

this is probably confusing but if you can help thanks.