Counta / Countif Problem - PLEASE HELP

[Ritz]

I have manual entry cells A80:A90. I am trying to write a formula that says if all of the cells are blank, then the value in A91 is blank -- if however there are "Yes" values in cells A80:A90, the take the total number of "Yes"*500. In other words, they get $500 for each "Yes."

The formula I wrote was (but it always returns a blank cell):

=if(counta(A80:A90=0),"",countif(A80:A90,"Yes")*500)

PLEASE HELP

 

[Richard Schollar]

Hi

Try:

=IF(COUNTA(A80:A90)=0,"",countif(A80:A90,"Yes")*500)

 

[VoG]

Try

=IF(COUNTBLANK(A80:A90)=11,"",COUNTIF(A80:A90,"Yes")*500)

 

[Ritz]

You are a GOD-SEND! You've replied to my requests before and you're always spot-on. I do have a question though, why did the original IF/THEN formual that I was working with not work? Using the two independently got the results I wanted, they just didn't seem to work together. . .