| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Fields 2
Ok, I need to elaborate from my previous e-mail. I have a worksheet that
contains various columns, ex Formula Name, Quantity, Cost ect. I need to add together the cost per formula name in another cell. Example below Formula Name Quantity Cost Apples 1 11.00 Bananas 2 10.00 Apples 50 550.00 Strawberries 15 9.50 So, if I summed up Apples cost, it would be 561, Bananas would be 10 and Strawberries would be 9.50. Can anyone help? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing Fields 2
Assuming your formula name is in column A and the cost is in column C. Try
this... =SUMPRODUCT(--(A2:A10="Bananas")*(C2:C10)) "kiwiplug6484" wrote in message ... Ok, I need to elaborate from my previous e-mail. I have a worksheet that contains various columns, ex Formula Name, Quantity, Cost ect. I need to add together the cost per formula name in another cell. Example below Formula Name Quantity Cost Apples 1 11.00 Bananas 2 10.00 Apples 50 550.00 Strawberries 15 9.50 So, if I summed up Apples cost, it would be 561, Bananas would be 10 and Strawberries would be 9.50. Can anyone help? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing Fields 2
Or
=SUMIF(A2:A10,"Apples",C2:C10) "kiwiplug6484" wrote in message ... Ok, I need to elaborate from my previous e-mail. I have a worksheet that contains various columns, ex Formula Name, Quantity, Cost ect. I need to add together the cost per formula name in another cell. Example below Formula Name Quantity Cost Apples 1 11.00 Bananas 2 10.00 Apples 50 550.00 Strawberries 15 9.50 So, if I summed up Apples cost, it would be 561, Bananas would be 10 and Strawberries would be 9.50. Can anyone help? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing Fields 2
Ok, that works, but now say I don't want to specify the formula name and I
just want it to calculate based off of that entire column containing like 100 or more formula names... is that possible? Thanks so much!! "Gaurav" wrote: Or =SUMIF(A2:A10,"Apples",C2:C10) "kiwiplug6484" wrote in message ... Ok, I need to elaborate from my previous e-mail. I have a worksheet that contains various columns, ex Formula Name, Quantity, Cost ect. I need to add together the cost per formula name in another cell. Example below Formula Name Quantity Cost Apples 1 11.00 Bananas 2 10.00 Apples 50 550.00 Strawberries 15 9.50 So, if I summed up Apples cost, it would be 561, Bananas would be 10 and Strawberries would be 9.50. Can anyone help? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing Fields 2
You can make a list of unique names. that you can do by using advance
filter. Select the rangego to FilterAdvance Filtercheck Unique Records Onlycheck Copy to Another LocationChoose Location (for example D2). Once you have that list in column D starting in D2. in E2 enter the formula =SUMIF($A$2:$A$1000,D2,$C$2:$C$1000) Or =SUMPRODUCT(--($A$2:$A$1000=D2)*($C$2:$C$1000)) and drag it down. "kiwiplug6484" wrote in message ... Ok, that works, but now say I don't want to specify the formula name and I just want it to calculate based off of that entire column containing like 100 or more formula names... is that possible? Thanks so much!! "Gaurav" wrote: Or =SUMIF(A2:A10,"Apples",C2:C10) "kiwiplug6484" wrote in message ... Ok, I need to elaborate from my previous e-mail. I have a worksheet that contains various columns, ex Formula Name, Quantity, Cost ect. I need to add together the cost per formula name in another cell. Example below Formula Name Quantity Cost Apples 1 11.00 Bananas 2 10.00 Apples 50 550.00 Strawberries 15 9.50 So, if I summed up Apples cost, it would be 561, Bananas would be 10 and Strawberries would be 9.50. Can anyone help? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Fields | Excel Discussion (Misc queries) | |||
| Summing fields based on color | Excel Discussion (Misc queries) | |||
| Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Summing Fields with Multiple Criteria | Excel Discussion (Misc queries) | |||
Linear Mode
