# Converting COUNTIF function for use in MSWorks Spreadsheet

#### Crazyted

##### New Member
Hello,
I've been searching the web looking for someone to help me convert a spreadsheet formula from an Excel spreadsheet for use in my Works 6.0 spreadsheet. The following formula is not recognized by works and I need something that will work...
=IF(COUNTIF(E3:R3,T3)>1,T3,MIN(W3:AJ3)+T3)
If anyone can help,,,please post away...

### 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.

##### MrExcel MVP
On 2002-09-26 23:13, Crazyted wrote:
Hello,
I've been searching the web looking for someone to help me convert a spreadsheet formula from an Excel spreadsheet for use in my Works 6.0 spreadsheet. The following formula is not recognized by works and I need something that will work...
=IF(COUNTIF(E3:R3,T3)>1,T3,MIN(W3:AJ3)+T3)
If a=nyone can help,,,please post away...

It seems COUNTIF is not available in Works 6.0.

Try the following...

Insert a row after row 3.
In E4 enter and copy across:

=(E3=\$T\$3)+0

Now use

=IF(SUM(E4:R4)>1,T3,MIN(W3:AJ3)+T3)

=IF(COUNTIF(E3:R3,T3)>1,T3,MIN(W3:AJ3)+T3)

#### Crazyted

##### New Member
OK,,I'm pretty new at all this formula stuff...there might be a problem. I have about 47 rows of info already. You say to add a row E4. I already have an E4 with another row of information...
Maybe it would be a good idea to explain the situation. This is a points tracking spreadsheet for a motorcycle racing series. We have fourteen races. The way we tally our year-end points is by getting rid of the two lowest scores for each rider. That's what this formula is doing is figuring out the second lowest score on the list. I already am using another formula for figuring out the lowest score and it is working fine. It's finding the second lowest score from the row that is giving me problems.

_________________
CrazyTed
Va Bch, VA
http://crazyted.tripod.com
This message was edited by Crazyted on 2002-09-26 23:35

##### MrExcel MVP
On 2002-09-26 23:32, Crazyted wrote:
OK,,I'm pretty new at all this formula stuff...there might be a problem. I have about 47 rows of info already. You say to add a row E4. I already have an E4 with another row of information...
Maybe it would be a good idea to explain the situation. This is a points tracking spreadsheet for a motorcycle racing series. We have fourteen races. The way we tally our year-end points is by getting rid of the two lowest scores for each rider. That's what this formula is doing is figuring out the second lowest score on the list. I already am using another formula for figuring out the lowest score and it is working fine. It's finding the second lowest score from the row that is giving me problems.

_________________
CrazyTed
Va Bch, VA
http://crazyted.tripod.com
This message was edited by Crazyted on 2002-09-26 23:35

Insert a new row before the current row 4 where you apply the SUM formula I suggested. You need to do this for each row of interest. This boils down to creating a help/ancillary row for each row of data to compensate for the absence of COUNTIF.

#### Crazyted

##### New Member
Ok,,,looks like when I get back from DC on Monday I'll be adding 47 more rows of info...
Thanks a bunch for the help though....

#### Crazyted

##### New Member
OK,,slight problem. It's not working when the two lowest scores are both zeros. It will skip all the zeros except the first one and then pick the next highest number. It's not working when the two lowest numbers are zeros.

Replies
13
Views
386
Replies
3
Views
238
Replies
2
Views
91
Replies
4
Views
335
Replies
5
Views
168

1,147,823
Messages
5,743,409
Members
423,792
Latest member
travisds

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back