Home

Excel Function

%3CLINGO-SUB%20id%3D%22lingo-sub-780914%22%20slang%3D%22en-US%22%3EExcel%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780914%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20names%20of%20Products%20in%20a%20column%2C%20and%20along%20their%20rows%20I%20have%20different%20data%20and%20info.%20Another%20column%20is%20the%20delivery%20method%2C%20so%20every%20product%20has%20a%20minimum%20of%20two%20records%20(rows)%20because%20of%20different%20delivery%20methods.%20Another%20row%20is%20the%20cost%20for%20every%20shipment%2C%20so%20every%20row%20has%20a%20cost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20function%20that%20could%20calculate%20the%20cost%20per%20product.%20by%20that%20I%20mean%20a%20function%20that%20could%20add%20up%20the%20total%20cost%20for%20a%20product%20regardless%20of%20it's%20delivery%20method.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20find%20the%20attached%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20in%20advance.%3C%2FP%3E%3CP%3EMohammad.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-780914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780995%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780995%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384778%22%20target%3D%22_blank%22%3E%40Khayyat93%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20Pivot%20Table%20to%20summarise%20by%20product%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125042i5E0C3A9EC0697F5A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780997%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384778%22%20target%3D%22_blank%22%3E%40Khayyat93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20return%20your%20desired%20results%2C%20you%20may%20simply%20use%20SUMIF%20like%20this%20in%20D2%2C%20copied%20down%20rows%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DSUMIF(A%3AA%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EA2%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EC%3AC)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Khayyat93
Occasional Visitor

Hi,

 

I have a list of names of Products in a column, and along their rows I have different data and info. Another column is the delivery method, so every product has a minimum of two records (rows) because of different delivery methods. Another row is the cost for every shipment, so every row has a cost.

 

I need a function that could calculate the cost per product. by that I mean a function that could add up the total cost for a product regardless of it's delivery method.

 

please find the attached example.

 

thanks in advance.

Mohammad.

2 Replies

@Khayyat93 ,

You may use Pivot Table to summarise by product

clipboard_image_0.png

 

@Khayyat93 

To return your desired results, you may simply use SUMIF like this in D2, copied down rows: 

=SUMIF(A:A,
A2,
C:C)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies