Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Writing Formulas for Lotus 123 Release 5

Status
Not open for further replies.
myeyesonly

myeyesonly

MIS
May 14, 2004
1
JM
I need a formula to count the number of data values greater than 3.49 in column of data with 20 rows. I tried using @count(A1..A20)>3.49, but it does not work. Thanks for any help you can offer.
 
Sort by date Sort by votes
With R5 you'll need to use @DCOUNT. You'll have to insert a row at A1 with a label, say "VALUES". Then you can just do:

@DCOUNT(A1..A21;0;A2>3.49)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

biroalfa
  • Locked
  • Question
Lotus 1-2-3 Release 9 for windows-page break problem
Replies
0
Views
171
biroalfa
biroalfa
Paolo64
  • Locked
  • Question
Lotus Notes 8.5 save attached file from “unread” messagges in a specific folder with excel vba
Replies
0
Views
104
Paolo64
Paolo64
artjog
  • Locked
  • Question
Lotus 123 Rel 5.0
Replies
0
Views
112
artjog
artjog
frenchpeter
  • Locked
  • Question
Choosing font or fill colour in Lotus 123V5 in Windows 7 1
Replies
3
Views
174
lotusfanbill
lotusfanbill
AbellM
  • Locked
  • Question
Lotus Notes 123 Nested If Then Statement
Replies
0
Views
127
AbellM
AbellM

Part and Inventory Search

Sponsor

Back
Top