not sure what function to use.

[soulantea]

Basically i have .

(Customer)

(10

20

25

40 )

(F

M)

(S)

<tbody>
</tbody>

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

(Customer (Drop down))

(10

20

25

40 )

(F

M)

(S) (=)

<tbody>
</tbody>

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]

	(Customer)	(10 20 25 40)	(F M)	S	D
	Bob	20	M	0
	Joe	2	F	2
BOB
	10	20	25	40
F	123	234	345	567
M	61.5	117	172.5	283.5
S	10
Joe
	10	20	25	40
F	42	68	81	66
M	21	34	40.5	33
S	10

<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[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