Macros needed (Count and Sum)

[ironsides]

Formulas needed

Col AB from lines 19 to 9999
has numbers 0.01 to 750.00

I need to count cells that contain numbers from 10.00 to 19.99
also the sum of those cells

 

[Joe4]

You can get those values pretty easily without VBA using SUM and COUNTIFS formulas (see: https://exceljet.net/formula/count-cells-between-two-numbers).
If you need it in VBA, note that you can use most Excel function in VBA by prefacing them with Application.Worksheetfunction.
For example:

Dim myRange as Range
Dim mySum as Double
Set myRange=Range("AB19:AB9999")
mySum = Application.Worksheetfunction.Sum(myRange)

 

[ironsides]

Thanks Joe for your reference Matt

 

[Joe4]

You are welcome Matt.
Post back if you run into any issues implementing it.

 

[jproffer]

Excel 2013/2016

	A	B	C

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]64.23[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]0.06[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1.23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]8.46[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]11.47[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]15.96[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]17.26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]19.54[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]411.25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]564.61[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]617.23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]659.27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]692.41[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]736.95[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B1[/TH]
[TD="align: left"]=COUNTIFS(A1:A15,">9.99",A1:A15,"<20")[/TD]
[/TR]
[TR]
[TH]C1[/TH]
[TD="align: left"]=SUMIFS(A1:A15,A1:A15,">9.99",A1:A15,"<20")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Maybe something like that?

Oops...guess I had that tab open for a while before posting.

EDIT again....I need to just stop for today. Missed the part about needing a macro (you were very clear...it's all my fault). Sorry again.

 

[ironsides]

Joe4 No problems for either sum and count using your suggested link. again,thanks, matt

 

[ironsides]

JProffer thanks for input Matt