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

J

J_Swoll

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

IF function inequality is not calculating correct result 3
Trying to either hide data in a cell or reduce the data to zero 2
Need formula help 4
An easier way? 8
Help with IF function 3
COUNTIF, only counting once if both cells contain the data 5
Two conditions in one cell. Help needed ASAP 3
Ongoing Issue - I have tried to clarify so that you understand 7

Top