Help changing counta/countifs formulas into macros

[tatendatiffany]

Hi

Could someone please help me i have created a couple of countif and counta formula but i want to turn them into macros. Please any guidance would be appreciated

=SUM(OFFSET(KTPT81T!G5,0,0,COUNT(KTPT81T!G5:G1000)))

=COUNTIF(TABF124!$G:K,"Y")
=COUNTA(KTPT80T!$G:$G)-2

how can i turn these into macros, i am still a beginner and am struggling to understand macros.

Thank you.

 

[tatendatiffany]

opps silly me i had used the sheet number name not the proper name...thanks for that.