create Summary report from information on the DATA Tab.

[steve400243]

Hello, The DATA Tab is a report that I run. Once ran I need a summary report created like shown on the CFS TOTALS Tab, I used the HIGHLIGHTED DATA from the DATA Tab to show my desired results, highlighted in yellow, On the CFS TOTALS Tab Thanks for any help you can provide.

[arnelgp]

only These columns need your Formula:

1. PCS SHIPPER PALLETIZED, and
2. PCS FEDEX PALLETIZED

[steve400243]

only These columns need your Formula:

1. PCS SHIPPER PALLETIZED, and
2. PCS FEDEX PALLETIZED

arnelgp,
Thank you for the Consolidate2 code! works great!
I could not get the right sumif, and countif formulas to work on my own. Appreciate the help!