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