DSUM function in EXCEL 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1302166%22%20slang%3D%22en-US%22%3EDSUM%20function%20in%20EXCEL%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302166%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20using%20the%20DSUM%20function.%20In%20the%20attached%20sheet%2C%20%22Order%20Sheet%22%20tab%2C%20I%20have%20a%20DSUM%20function%20under%20column%20%22Total%22%2C%20but%20it%20returns%20%22%23VALUE!%22.%20Not%20sure%20what%20is%20wrong%20with%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20row%20on%20the%20sheet%20represents%20a%20Food%20Item%20ordered.%20Each%20customer%20can%20have%20more%20than%20one%20row%20for%20food%20items.%20My%20objective%20is%20to%20store%20the%20total%20price%20of%20each%20order%20under%20the%20column%20%22Total%22%20just%20on%20the%20first%20Order%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20left%20most%20columns%20are%20to%20have%20a%20unique%20ID%20for%20each%20order%20and%20a%20sequence%20number%20for%20each%20order%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help%20with%20this%20function%20or%20any%20other%20function%20that%20could%20do%20the%20job.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaad%20Soliman%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1302166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi,

 

I have a problem using the DSUM function. In the attached sheet, "Order Sheet" tab, I have a DSUM function under column "Total", but it returns "#VALUE!". Not sure what is wrong with the formula.

 

Each row on the sheet represents a Food Item ordered. Each customer can have more than one row for food items. My objective is to store the total price of each order under the column "Total" just on the first Order line.

 

The left most columns are to have a unique ID for each order and a sequence number for each order item.

 

Appreciate your help with this function or any other function that could do the job.

 

Thanks

 

Saad Soliman