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

G

Guest

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.
 
G

Gary

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

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

not sure..
 
D

David Biddulph

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF or( If And ) can't get it to work 2
Countif cell if other cells match criteria 3
Trying to either hide data in a cell or reduce the data to zero 2
Wobbled countif and conditional format Results 9
Need formula help 4
Referencing cells in different worksheets 1
Sumif across a table 1
IF function inequality is not calculating correct result 6

Top