2 macros needed

[ironsides]

starts line 19

if col M =>1, SUM col AM

also COUNT

thanks ironsides

 

[davesexcel]

I find your lack of effort in this question disturbing.....

 

[ironsides]

i need an excel expert not a doctor

 

[Macropod]

Your problem description is sparse, to say the least, and it is by no means clear what the expected result is or where the output is to go.

Please read the Guidelines for Forum Use: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[Michael M]

Hope it's what you want.....with very little info provided...
Not a way to win friends, I'm afraid !!

x = 0
Y = 0
For r = 19 To lr
    If Range("M" & r).Value >= 1 Then
        x = x + Range("AM" & r).Value
        Y = Y + 1
    End If
Next r
MsgBox "Count is " & Y
MsgBox "Sum is " & x

 

[ironsides]

Michael M thank you ironsides