wesleyterrill
New Member
- Joined
- Feb 9, 2016
- Messages
- 15
Hello, everyone!
Every day, I use several reports that look like the table below (I can export as csv or xlsx.) I need to be able to pull data only from certain headers - specifically all 1900 and 3900 groups. (In my actual data, that will include 1901, 1902, 1903, etc.) But I need to exclude the 2900 categories.
What would be the best way to go about this? If the formula were correct, it should add up the 1900 and 3900 totals: $575 (D4) + $95 (D8) + $450 (D17) + $350 (D20). Any help would be greatly appreciated!
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]1905 - Doors[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #1[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$250[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #2[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$325
[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$575[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]1945 - Windows[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #3[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$50[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #4[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$45[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$95[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]2905 - Maintenance[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #5[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$25[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$25[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]2975 - Repair[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #6[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$40[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$40[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]3905 - Construction[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #7[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$450[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$450[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]3925 - Equipment[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #8[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$350[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$350[/TD]
[/TR]
</tbody>[/TABLE]
Every day, I use several reports that look like the table below (I can export as csv or xlsx.) I need to be able to pull data only from certain headers - specifically all 1900 and 3900 groups. (In my actual data, that will include 1901, 1902, 1903, etc.) But I need to exclude the 2900 categories.
What would be the best way to go about this? If the formula were correct, it should add up the 1900 and 3900 totals: $575 (D4) + $95 (D8) + $450 (D17) + $350 (D20). Any help would be greatly appreciated!
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]1905 - Doors[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #1[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$250[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #2[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$325
[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$575[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]1945 - Windows[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #3[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$50[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #4[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$45[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$95[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]2905 - Maintenance[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #5[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$25[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$25[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]2975 - Repair[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #6[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$40[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$40[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]3905 - Construction[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #7[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$450[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$450[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]3925 - Equipment[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Invoice #8[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]$350[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]$350[/TD]
[/TR]
</tbody>[/TABLE]