not sure what function to use.

[soulantea]

Basically i have .

[TABLE="width: 665"]
<tbody>[TR]
[TD="width: 217"](Customer)[/TD]
[TD="width: 64"](10[/TD]
[TD="width: 64"]20[/TD]
[TD="width: 64"]25[/TD]
[TD="width: 64"]40 )[/TD]
[TD="width: 64"](F[/TD]
[TD="width: 64"]M)[/TD]
[TD="width: 64"](S)[/TD]
[/TR]
</tbody>[/TABLE]


under customer are different sorts, now i want to somehow get a sum from only one of 10,20,25,40 and then based on f m or s a conditional answer?

like its customer bob had a 1 10 is F or M and 1 or 2 S

not sure what function, i thought maybe count if, but more in depth, i have a pre set of prices for depending on witch customer on witch size and F or M and yes or no on S,

and i would also like customers to be in a drop down box, i can put all prices in another area and hide them so i can point what what the price be if what ever of these options are set to. but customer in a drop down.

so example

[TABLE="width: 665"]
<tbody>[TR]
[TD="width: 217"](Customer (Drop down))[/TD]
[TD="width: 64"](10[/TD]
[TD="width: 64"]20[/TD]
[TD="width: 64"]25[/TD]
[TD="width: 64"]40 )[/TD]
[TD="width: 64"](F[/TD]
[TD="width: 64"]M)[/TD]
[TD="width: 64"](S) (=)[/TD]
[/TR]
</tbody>[/TABLE]
bob 20 M 0 $259.51
Joe 40 F 2 $659.24

any help would be great, i know what im doing in excel... but this seems to be beyond me.

 

[FormR]

Welcome to the forum!

Is this what your sheet looks like and are you trying to calculate column E?

Excel Workbook
	A	B	C	D	E
1	(Customer)	(10 20 25 40)	(F M)	(S)	(=)
2	Bob	20	M	0	259.51
3	Joe	2	F	2	659.24
Sheet1

If so, what does the pre-set list of prices looks like and where is it?

i have a pre set of prices for depending on witch customer on witch size and F or M and yes or no on S,

 

[soulantea]

[TABLE="width: 553, align: center"]
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD](Customer)[/TD]
[TD](10 20 25 40)[/TD]
[TD](F M)[/TD]
[TD]S[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Bob[/TD]
[TD]20[/TD]
[TD]M[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Joe[/TD]
[TD]2[/TD]
[TD]F[/TD]
[TD]2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]BOB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]234[/TD]
[TD="align: right"]345[/TD]
[TD="align: right"]567[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD="align: right"]61.5[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]172.5[/TD]
[TD="align: right"]283.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD="colspan: 4"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Joe[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]66[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]40.5[/TD]
[TD="align: right"]33[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD="colspan: 4"]10[/TD]
[TD]







[/TD]
[/TR]
</tbody>[/TABLE]

 

[soulantea]

trying to fill d automatically with dorp downs on customer?

any info would be great.

 

[FormR]

Hi, I think that you need to explain what the "d" values should be for the example data you have provided and how they are arrived at?

When I paste your example into Excel it looks like this, is this the correct layout?

p.s. see these links for ways to post your example data:

http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189
Download

Excel Workbook
	A	B	C	D	E	F
1	*	(Customer)	(10 20 25 40)	(F M)	S	D
2	*	Bob	20	M	0	??
3	*	Joe	2	F	2	??
4	*	*	*	*	*	*
5	BOB	*	*	*	*	*
6	*	10	20	25	40	*
7	F	123	234	345	567	*
8	M	61.5	117	172.5	283.5	*
9	S	10	*	*	*	*
10	*	*	*	*	*	*
11	Joe	*	*	*	*	*
12	*	10	20	25	40	*
13	F	42	68	81	66	*
14	M	21	34	40.5	33	*
15	S	10	*	*	*	*
Sheet1