PLEASE HELP—Macro

[Wildcats23]

Hello,
I need help writing a Macro that can run a dynamic sum(countifs,countifs) in a range of D3:AD29. The formula has to reference row 2 and column 1 as part of its inputs. As an example the hard code formula looks something like this =sum(countifs(fixed,row reference,fixed,column reference ),Countifs(fixed, row reference, fixed, column reference). I would like this to run in the background so it only shows the cell values when I click any cell in the D3:D29 range. Thank you!!!

 

[Michael M]

Have you tried using the Macro recorder ?
Can you also give us a living example of the formula AND the data ?

 

[Wildcats23]

I currently have the entire Range of D3:AD29 already filled with the individual formulas I'm talking about. To better clarify, I wanted to have the macro run those formulas in the background so when I present I can click into the cell an it wont show the formula just the result. So I don't think I could use the recorder in that case. Do you know how to do this?