SUMIF per MONTH

[Jarvin24]

Hi Everyone,

I hope someone could help me with my problem.

Here it is... I have two sheets

RAW DATA: Where all the transaction for the month is located
BUDGET: Where the budget for 2016 (Column B:M) is located. It's FIXED.

What I am doing every month is to compare the BUDGET vs ACTUALS by computing the total expense of the month per GL CODE (COLUMN A). What I usually do is to COPY the formula and just CHANGE it to the current MONTH.

I was hoping if there is a way to CODE this using VBA... in one RUN, it will put the TOTAL ACTUAL EXPENSE to the right MONTH which is in COLUMN N to Y.

Thank you in advance.

^_^ JB

[TMS]

You don't need VBA, just use SUMIFS with a Custom Number Format to hide zeroes.

Or, more flexible, use a Pivot Table.

Regards, TMS

[Jarvin24]

Hi Buddy...

Right.. Actually that is what I'm doing.. SUMIFS every month and just change it with the current... But I was just wondering if its possible to do it in VBA.. eheheh..

But if its not.. I'm okay with the current ^_^ Just want to learn how..

Tnx tnx

[TMS]

Why are you changing it every month? You have a column header that contains the month name. Use that.

On iPad at the moment so can't see details. Will check back later.

[TMS]

Adjust the formula in N3 and drag across and down:

Please Login or Register  to view this content.

See the updated example. It also has an example of a Pivot Table.


Regards, TMS