Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding text values in Excel
I'm trying to create formulas for an order form. In column B I have the size
of the product (small, medium, large) and in column C I have "Left" or "Right". I'd like to write a formula telling me the totals for each: "Small, left" "small, right" "medium left" "medium right" "large left" large right" etc. I've tried just about every function that's been suggested for similar problems and no luck. I've even tried the pivot tables. Thanks for any input! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding text values in Excel
You could set up a summary table like this:
Left Right Small Medium Large then you could have a formula to give you the counts in the appropriate cells. Suppose the label "Left" above is in M1, then in M2 you could have this formula: =SUMPRODUCT(($B$1:$B$100=$L2)*($C$1:$C$100=M$1)) Adjust the ranges to suit your data (I've assumed 100 rows), then you can copy this across and down the cells in your summary table. Hope this helps. Pete On Jan 18, 12:44*pm, Roadrunner wrote: I'm trying to create formulas for an order form. In column B I have the size of the product (small, medium, large) and in column C I have "Left" or "Right". I'd like to write a formula telling me the totals for each: *"Small, left" "small, right" "medium left" "medium right" "large left" large right" etc. I've tried just about every function that's been suggested for similar problems and no luck. I've even tried the pivot tables. Thanks for any input! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding text values in Excel
Hi,
Not sure what you want, do you want to get the text Small, left if yes use =B2&" "&","&C2 "Roadrunner" wrote: I'm trying to create formulas for an order form. In column B I have the size of the product (small, medium, large) and in column C I have "Left" or "Right". I'd like to write a formula telling me the totals for each: "Small, left" "small, right" "medium left" "medium right" "large left" large right" etc. I've tried just about every function that's been suggested for similar problems and no luck. I've even tried the pivot tables. Thanks for any input! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding different text values | Excel Discussion (Misc queries) | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
drop down list and adding numeric values to text | Excel Discussion (Misc queries) | |||
adding values with text | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |