Auto total for every month

[omsh14]

Any one help me for automatically sum to be calculated in excel.
Say i have attahced the file evey month expens for 12 months in 3 column like actual exp for last year, budget for the year and actual for current year. I need the formula when ever i have updated the data of every month total column shows total automatically.
Thanks in advance.

[:) Sixthsense :)]

In AM4 Cell

=SUMPRODUCT((TEXT($B$1:$AK$1,"YYYY")=TRIM(SUBSTITUTE(UPPER(AM$1),"YTD.","")))*($B$2:$AK$2=AM$2),$B4:$AK4)

Drag it down and right...

[omsh14]

It is fine. But i need the total like as below.
01-- i am not going to hide the all column. only i will keep column till march.
02-- Which ever column UN-hide that total only should show in last column.(it means actual and budget.
Plz help on this.
Thanks

[omsh14]

Sorry i have mentioned wrongly earlier post.

But i need the total like as below.
01-- i am going to hide the all column. only i will keep column till march.
02-- Which ever column UN-hide that total only should show in last column.(it means actual and budget.
Plz help on this.
Thanks

[:) Sixthsense :)]

Just limit the reference to that range alone

In AM4 Cell

=SUMPRODUCT((TEXT($B$1:$J$1,"YYYY")=TRIM(SUBSTITUTE(UPPER(AM$1),"YTD.","")))*($B$2:$J$2=AM$2),$B4:$J4)

Drag it down and right...

[omsh14]

Really very nice one.
But When i am going to un-hide the april automatically can update the formula?
Suppose one cell i will update say May, the formula can automatically update.
I need like that formula.
Please help me.
I am sorry to treble you
thanks-shankar

[:) Sixthsense :)]

I created an UDF to result whether the column is hidden.

Please Login or Register  to view this content.

Whenever you hide / unhide a column then just press F2 on any cell and press Enter to let the UDF to recalculate.

Refer the attached file for details

[omsh14]

Thanks a lot