=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
 

I am creating a spread sheet and I need to add colums together based on two
different inputs. the "IF statement" seems to to work fine with only one
condition such as:
=if(F6="C06",E6,0) + if(F7="C06",E7,0)
This statement will add E6 to E7 if the F cell is true and it works, How do
I check the condition of two cells.

=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
 

please elaborate...is it something like...

=IF(AND(F6="C06",F7="C06"),(E6+E7),0)

not sure..


"J_Swoll" wrote in message
...
I am creating a spread sheet and I need to add colums together based on two
different inputs. the "IF statement" seems to to work fine with only one
condition such as:
=if(F6="C06",E6,0) + if(F7="C06",E7,0)
This statement will add E6 to E7 if the F cell is true and it works, How
do
I check the condition of two cells.

=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
 

Please remember to include the details of your question in the body of the
text, as readers may well not notice what you've hidden in the subject line.

=if(AND(F6="C06",G6="A"),E6,0) + if(F7="C06",E7,0)
--
David Biddulph

"J_Swoll" wrote in message
...
I am creating a spread sheet and I need to add colums together based on two
different inputs. the "IF statement" seems to to work fine with only one
condition such as:
=if(F6="C06",E6,0) + if(F7="C06",E7,0)
This statement will add E6 to E7 if the F cell is true and it works, How
do
I check the condition of two cells.

=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
 

=SUMIF(F6:F7,"C06",E6:E7)


"J_Swoll" wrote:

I am creating a spread sheet and I need to add colums together based on two
different inputs. the "IF statement" seems to to work fine with only one
condition such as:
=if(F6="C06",E6,0) + if(F7="C06",E7,0)
This statement will add E6 to E7 if the F cell is true and it works, How do
I check the condition of two cells.