Macro to count and sum values paste in a table based on multiple criteria

[Mavericks334]

Hi,

I have to sheets in an excel workbook. One has a table and the other has the data.

Below is the snapshot of the table and the data sheets.

Data sheet column headers:

Month

TIS Fund ID

Descr

DOMICILE

NAC Factor

FAR Factor

<COLGROUP><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 138pt; mso-width-source: userset; mso-width-alt: 6729" width=184><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" width=188><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" span=2 width=80><TBODY>
</TBODY>

Table information.

FY13

Month

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

TIS number = 0

FAR Factor ID's = 0

FAR Factor >0

Sum of FAR Factor

<COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6838" width=187><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" span=2 width=28><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 987" width=27><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1097" width=30><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" span=2 width=29><TBODY>
</TBODY>

Based on the Month & fiscal year the macro should go respective column and update information.

It needs to check if TIS id's are 0 Then count them and paste in the TIS Number = 0 Section
Then it needs to go to the FAR Factor Column count all FAR factors ID's that are 0 except for the ones where TIS Number = 0 and paste the count in FAR id's section.
Then it should count all the non zero far factor id's and paste it in the FAR Factor > 0
and sum the same values and paste in the FAR Factor Section.

Could someone help me.

Regards,

Renato.