Ignoring blank cells or zero values when using a formula

bc2515

New Member
Joined
Dec 28, 2005
Messages
6
I have a speadsheet and I want the formulas to calculate based on 34 rows. However, frequently there will not be data in some of those rows. I want the formula to ignore the blank cells. Right now, if I leave the cells blank I receive #N/A. Is there something that I can add to this formula so that it does not rank the blank cells? There are other

Rank Column
=RANK(B2,B$2:B$34)+COUNTIF(B$2:B2,B2)-1
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,306
Members
412,716
Latest member
thviid
Top