[Solved]Duplicate Sumif Function Using Vba Macro Program Sum Transactions April First Dimension Va Q37181402

Duplicate the SumIF function using a VBA Macro program. Sum alltransactions if in April. You should first dimension any variablesneeded, and then write a loop to sum the values. In the loop, youwill have an if statement to test for the criteria to see if itshould be added to the total.

O WorkSheet for Macro VBA programming example.xlsx (1 page) Q Search Cust ID Sales Transaction Month of Transaction Type of Trans $769.04 $246.74 S434.58 S180.63 S136.16 $474.66 $799.35 S623.58 $424.36 $847.26 S141.13 $274.34 S466.18 $580.43 $614.88 $915.87 S966.37 $889.54 S391.99 S979.63 S192.49 S633.51 $945.00 $811.16 S595.93 $829.87 S37159 S605.53 $486.76 $242.35 $376.12 S647.86 $277.08 $432.43 $107.72 S120.29 $537.76 $823.00 $22127 S148.51 $693.94 $365.79 S621.90 $877.04 S658.12 S637.89 S956.59 $841.39 S512.80 $443.01 2 18 10 18 January 74 32 10 10 53 July 74 10 July July July Show transcribed image text O WorkSheet for Macro VBA programming example.xlsx (1 page) Q Search Cust ID Sales Transaction Month of Transaction Type of Trans $769.04 $246.74 S434.58 S180.63 S136.16 $474.66 $799.35 S623.58 $424.36 $847.26 S141.13 $274.34 S466.18 $580.43 $614.88 $915.87 S966.37 $889.54 S391.99 S979.63 S192.49 S633.51 $945.00 $811.16 S595.93 $829.87 S37159 S605.53 $486.76 $242.35 $376.12 S647.86 $277.08 $432.43 $107.72 S120.29 $537.76 $823.00 $22127 S148.51 $693.94 $365.79 S621.90 $877.04 S658.12 S637.89 S956.59 $841.39 S512.80 $443.01 2 18 10 18 January 74 32 10 10 53 July 74 10 July July July

Expert Answer

---

Answer to Duplicate the SumIF function using a VBA Macro program. Sum all transactions if in April. You should first dimension any… . . .