J
Jambruins
I am trying to use the following forumla:
=SUMIF((Z2:Z44),ISTEXT(Z2:Z44),AA2:AA44)/100
I have a formula setup in AA that either has a number in it or a #NUM!.
Column Z is either blank or has a W or L in it. I want my cell to use the
above formula to add up all the numbers in column AA that have a W or L in
column Z. For some reason the above formula isn't working. It is giving me
a 0 when it should be giving me 1. Thank you.
I also tried this formula but it didn't work either
=SUMIF((Z2:Z44),(OR("W","L")),AA2:AA44)/100
=SUMIF((Z2:Z44),ISTEXT(Z2:Z44),AA2:AA44)/100
I have a formula setup in AA that either has a number in it or a #NUM!.
Column Z is either blank or has a W or L in it. I want my cell to use the
above formula to add up all the numbers in column AA that have a W or L in
column Z. For some reason the above formula isn't working. It is giving me
a 0 when it should be giving me 1. Thank you.
I also tried this formula but it didn't work either
=SUMIF((Z2:Z44),(OR("W","L")),AA2:AA44)/100