Access to excel connection and automation

Hello Team,

I've created a connection between access and excel, could you please provide steps for using automation like for using countif sumif formulas

Hello Alan,

lets take an example

had a data in ms access for Jan to Dec

under jan colulm I want the count for Jan w hick i slinked from ms access

in the same way data should be updated for all the months automatically