count as either 1 or 2 - plus a heap more

[ro801]

Hi
I previously posted on here this morning and got a very quick answer to my my original question. I now need to add more criteria onto the same formula (or change it) but can't seem to work out how, and would appreciate some help.
The question i asked was:
"I need a formula that assigns a score of 1 point for each cell with 'Y' in it. But column 'e' is worth 2 points if it has a 'y' in it."
The answer i used (and it worked) was:
=COUNTIF(A1:E1,"Y")+1*(E1="Y")
So now i have 3 more columns, the first 2 are counted together so if either one is true then thats 1 point. The criteria would be either "Y" in one column or <=35 in the other.
The third criteria is worth 1 point and is a value >=75.
Any help would be real helpful...again!
Thanks
Owen

 

[Weaver]

Does this formula have to apply to just 1 row or a whole grid of cells?

 

[ro801]

Thanks for your reply; it would only apply to each row, never anything on different rows or sheets.
Owen