Thread: sumif help...
View Single Post
  #1   Report Post  
Jambruins
 
Posts: n/a
Default sumif help...

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