I am trying to format the following formula but am not sure how to do it.
In sentence form, I'm trying to say: If column/row C59=Tom and column/row G59=**** and Column/row K59=Harry, then column/row R59 =1 or 0 if false. =IF(AND(C59="Tom"*G59="****"*K59="Harry"),1,0)
Additionally, what I'd really like to do is add a range of info.I.e.
If any rows fit this criteria they will sum the total.
=IF(AND(C29:59="Tom"*G29:59="****"*K29:59="Harry"),1,0)
WHere am I going wrong?
In sentence form, I'm trying to say: If column/row C59=Tom and column/row G59=**** and Column/row K59=Harry, then column/row R59 =1 or 0 if false. =IF(AND(C59="Tom"*G59="****"*K59="Harry"),1,0)
Additionally, what I'd really like to do is add a range of info.I.e.
If any rows fit this criteria they will sum the total.
=IF(AND(C29:59="Tom"*G29:59="****"*K29:59="Harry"),1,0)
WHere am I going wrong?