Hi,
I have a sheet that looks like this:
[TABLE="width: 2859"]
<tbody>[TR]
[TD][/TD]
[TD]GSM number[/TD]
[TD]Extension[/TD]
[TD]Group name[/TD]
[TD]Subgroup name[/TD]
[TD]Name GSM number[/TD]
[TD]User ref1[/TD]
[TD]User Ref2[/TD]
[TD]Call date[/TD]
[TD]Call time[/TD]
[TD]Call duration[/TD]
[TD]Destination[/TD]
[TD]Zone/Country/Operator[/TD]
[TD]Tariff[/TD]
[TD]Type[/TD]
[TD]Supplementary services[/TD]
[TD]Indicative tariff[/TD]
[TD]Usage amount[/TD]
[TD]Currency[/TD]
[TD]Country of destination[/TD]
[TD]Account number[/TD]
[TD]Discount Indicator[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-13[/TD]
[TD] xxxxxxxxxxxx[/TD]
[TD][/TD]
[TD]Unfiled - Niet toegekend - Non attribué[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]28-Jan-13[/TD]
[TD="align: right"]16:58:53[/TD]
[TD="align: right"]00:02:05[/TD]
[TD="align: right"]478882664[/TD]
[TD]On Site[/TD]
[TD]Normal[/TD]
[TD]Communications nationales[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD]EUR[/TD]
[TD][/TD]
[TD="align: right"]10736059[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-13[/TD]
[TD] xxxxxxxxxxxx[/TD]
[TD][/TD]
[TD]Unfiled - Niet toegekend - Non attribué[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]29-Jan-13[/TD]
[TD="align: right"]16:47:21[/TD]
[TD="align: right"]00:11:37[/TD]
[TD="align: right"]493194255[/TD]
[TD]Mobistar[/TD]
[TD]Normal[/TD]
[TD]Communications nationales[/TD]
[TD]R[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.3803[/TD]
[TD]EUR[/TD]
[TD][/TD]
[TD="align: right"]10736059[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-13[/TD]
[TD] xxxxxxxxxxxx[/TD]
[TD][/TD]
[TD]Unfiled - Niet toegekend - Non attribué[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02-Jan-13[/TD]
[TD="align: right"]21:31:21[/TD]
[TD="align: right"]00:01:00[/TD]
[TD]31 111 483 392[/TD]
[TD]From Site[/TD]
[TD]Réduit[/TD]
[TD]Communications internationales[/TD]
[TD]R[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.06[/TD]
[TD]EUR[/TD]
[TD][/TD]
[TD="align: right"]10736059[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]
i'd like to add up, using a macro, the "Usage amount" if the type is "Communication nationals" only.
I have a sheet that looks like this:
[TABLE="width: 2859"]
<tbody>[TR]
[TD][/TD]
[TD]GSM number[/TD]
[TD]Extension[/TD]
[TD]Group name[/TD]
[TD]Subgroup name[/TD]
[TD]Name GSM number[/TD]
[TD]User ref1[/TD]
[TD]User Ref2[/TD]
[TD]Call date[/TD]
[TD]Call time[/TD]
[TD]Call duration[/TD]
[TD]Destination[/TD]
[TD]Zone/Country/Operator[/TD]
[TD]Tariff[/TD]
[TD]Type[/TD]
[TD]Supplementary services[/TD]
[TD]Indicative tariff[/TD]
[TD]Usage amount[/TD]
[TD]Currency[/TD]
[TD]Country of destination[/TD]
[TD]Account number[/TD]
[TD]Discount Indicator[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-13[/TD]
[TD] xxxxxxxxxxxx[/TD]
[TD][/TD]
[TD]Unfiled - Niet toegekend - Non attribué[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]28-Jan-13[/TD]
[TD="align: right"]16:58:53[/TD]
[TD="align: right"]00:02:05[/TD]
[TD="align: right"]478882664[/TD]
[TD]On Site[/TD]
[TD]Normal[/TD]
[TD]Communications nationales[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD]EUR[/TD]
[TD][/TD]
[TD="align: right"]10736059[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-13[/TD]
[TD] xxxxxxxxxxxx[/TD]
[TD][/TD]
[TD]Unfiled - Niet toegekend - Non attribué[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]29-Jan-13[/TD]
[TD="align: right"]16:47:21[/TD]
[TD="align: right"]00:11:37[/TD]
[TD="align: right"]493194255[/TD]
[TD]Mobistar[/TD]
[TD]Normal[/TD]
[TD]Communications nationales[/TD]
[TD]R[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.3803[/TD]
[TD]EUR[/TD]
[TD][/TD]
[TD="align: right"]10736059[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-13[/TD]
[TD] xxxxxxxxxxxx[/TD]
[TD][/TD]
[TD]Unfiled - Niet toegekend - Non attribué[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02-Jan-13[/TD]
[TD="align: right"]21:31:21[/TD]
[TD="align: right"]00:01:00[/TD]
[TD]31 111 483 392[/TD]
[TD]From Site[/TD]
[TD]Réduit[/TD]
[TD]Communications internationales[/TD]
[TD]R[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.06[/TD]
[TD]EUR[/TD]
[TD][/TD]
[TD="align: right"]10736059[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]
i'd like to add up, using a macro, the "Usage amount" if the type is "Communication nationals" only.