Sum data

[peacepower]

Hi,
I need to sum the following:
Weight and Cost.
I only want to sum it when there is a shipment number associated with the weight and the cost. It means that I have more than one shipment when I have a shipment number.
If there are no numbers the cells are not blank but there is an _. If that’s the case they should stay the same (I don't need to sum up) as _ indicate only one shipment.
How can I get this solved?
Thanks a lot for the help.

[June7]

Need to know table structure. Show example data. Sounds like should be a simple SELECT with aggregate calcs and filter criteria.

Build a report with Grouping & Sorting and aggregate calcs.

What field has an _? Number type fields cannot have non-numeric characters.

[peacepower]

Hi June7,
Thanks for taking the time to look at this. I will give it a try and look at aggregate calcs. basically all it is is this, I want same MBOL #s on one line (these are fields examples)
BOL 1788771 1788779 1788332
MBOL _ 123 123 -> MBOL has a _ is this going to be a problem.
Then each one would have a value so i want cell 2 and 3 below combined.
TOT WGT 36 204 288

[June7]

Still not making sense to me. BOL and MBOL are field names? How do shown numbers result in TOT WGT 36 204 288?