need help with formula

[lt123]

A B C D E F D
6000 2 26 Yes 52 4500 0
6000 1 24 Yes 24 4750 0
4500 1 26 Yes 26 5000 0
4500 2 24 Yes 48 5250 0
8500 1 26 Yes 26 5500 0
8000 1 24 Yes 24 5750 0
8000 1 26 Yes 26 6000 0
4750 1 Yes 0 6250 0
6000 1 24 Yes 24 6500 0
5500 1 24 Yes 24 6750 0
5500 3 24 Yes 72 7000 0
5500 2 26 Yes 52 7250 0
5500 2 24 Yes 48 7500 0
5500 2 26 Yes 52 7750 0
4750 1 26 Yes 26 8000 0

need help
trying to sort this couple days now, not very good in excel.
would appreciate if somebody could help.
thank you.
(Need to look in Column A and If its matches F1, and if yes in the same row look for E4) + sum them all together.

Its counting warehouse stock, production made total.
All suggestions are welcome.

 

[Noodleski]

I'm afraid your explanation is confusing (to me)

So basically, you want to compare each value in column A against cell F1, check if there's "yes" in column D and if both of these conditions are met, retrieve the value in E4 and sum something (like, what column?)

Could you perhaps give a few rows where you clarify the desired logic?

 

[Michael M]

The sample you provided doesn't really help !
you could use the HTML Maker in my tag to paste a sample here...OR...upload a sample worksheet to dropbox and post the link back here !!!

 

[StephenCrump]

Just a guess, because your layout and explanation aren't clear. Perhaps something like:

F2: =SUMIFS(E4:E18,A4:A18,F1,D4:D18,"Yes")

Excel 2010

	A	B	C	D	E	F	G
1					Find	4500
2					Sum	74
3
4	6000	2	26	Yes	52	4500	0
5	6000	1	24	Yes	24	4750	0
6	4500	1	26	Yes	26	5000	0
7	4500	2	24	Yes	48	5250	0
8	8500	1	26	Yes	26	5500	0
9	8000	1	24	Yes	24	5750	0
10	8000	1	26	Yes	26	6000	0
11	4750	1		Yes	0	6250	0
12	6000	1	24	Yes	24	6500	0
13	5500	1	24	Yes	24	6750	0
14	5500	3	24	Yes	72	7000	0
15	5500	2	26	Yes	52	7250	0
16	5500	2	24	Yes	48	7500	0
17	5500	2	26	Yes	52	7750	0
18	4750	1	26	Yes	26	8000	0

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

 

[lt123]

Yes,your right
StephenCrump, this is what i want, but I tryed ur formula and come back with 0.

 

[StephenCrump]

I tryed ur formula and come back with 0.

The formula works for the data I've posted, but this is just my guess as to what your data looks like.

If your data is different, you'll get a different result. You can either try to modify the formula for your data layout, or as Michael M suggested, post your data using an HTML maker so we can understand it.

See Part B here for another couple of ways you can post screenshots: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[lt123]

it won't allow me to access, im at work and its blocked

Im getting formula: =SUMIFS(G14:G43,C14:C43,I14,F14:F43,"Yes") but its returning value 0

 

[lt123]

it won't allow me to access, im at work and its blocked

Im getting formula: =SUMIFS(G14:G43,C14:C43,I14,F14:F43,"Yes") but its returning value 0

I got it working, problem was with data validation, I had the option to chose, how I can fix that?

 

[StephenCrump]

It sounds like:

- The formula works?
- You have a different problem caused by data validation?

You'll have to give us more detail ...

- What is the problem?
- What does your data look like, and where is the data validation?
- What results do you want to see?
- What results are you actually getting?