Excel Help - return specific value if cells contain data

[drdeutsch]

I need an excel formula that checks a specific number of rows (let's say A1:Z1). If the cells have data, I want to add 5 for every cell that has data (it doesn't matter what the data in the cell is. Just as long as it has data). So if 10 cells have data, I would get a value of 50.

Is this possible? I'm having a brainfart and can't figure out how to do it.

Thanks.

 

[arkamw]

How about

=(counta(a1:z1))*5

Seems to work ok on a test. This will count cells with any data in it.

 

[drdeutsch]

You are awesome! Thanks!