In Excel, I would like to capture all values from 50 to 99

[Guest]

I need help with a formula to capture values >=50 to <=99 in a row (not column)

 

[BruceM]

Depending on what exactly you mean by "capture" you may be able to get what
you need with CountIf or SumIf, but the question would be better asked in an
Excel newsgroup. This group is for Microsoft Access, a relational database
program. The web interface may have misdirected you here.

 

[Al Campagna]

Shiek,
This news group deals with Microsoft Access, a realtional database application.
If my response does not meet your needs, try posting this question in a appropriate
spreadsheet group (I assume Excel).

For the sake of clarity, I would suggest that you Bold those items >=50 and <=90, so
the viewer can see what numbers went into the total you want.
Create a Function that adds only the Bold numbers...
Public Function SumBold(rngSumRange As Range) As Single
Dim rngCell As Range
For Each rngCell In rngSumRange
If IsNumeric(rngCell.Value) Then
If rngCell.Font.Bold = True Then
SumBold = SumBold + rngCell.Value
End If
End If
Next rngCell
End Function

Then... SumBold(A1:A20) would only add the bolds.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."