Sum based on horizontal and vertical match

I need a help in the attached excel file

I need a lookup formula that can search the brand with the salesman name, to get the quantity sold.

Then it sum all the sold quantities, and put it in another table

Example: Brand A sold by salesman (Asif), then the excel should take 45 + 60, and add them in the other table

Try the SUMIF function

What does not work? Which error do you get? What have you tried?

SUMIF function is explained in XL help - Hundreds of examples on the forum

Also pls, take a few minutes to read forum rules, because:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thanks for title changing.

I don't know what Pepe has in his mind, but i am not able to see in which way we'll be able to match the conditions in way that you have the layout of your data.

The layout of your data is very strange.. Can you tell us how you use the SUMIF that gives you the correct result only for Brand? Then SUMIFS function maybe do the job..

I don't know what Pepe has in his mind

Not much Fotis, it's the first working day after the weekend

I hadn't sen there were two conditions involved so, as you say, SUMIFS is the way to go

Correct my friend. I forgot that last Sunday was Easter for you.

You are welcome.

As i said your data layout(as my opinion) are strange and it's difficult(maybe impossible) to get the expected result.

I change a little tour layout and this formula gives you the expected results.

=SUMPRODUCT(($B$4:$B$30=$K4)*($E$4:$E$30=M$3)*($C$4:$C$30))

Yes it is. I use a helper and hidden column with salemen names.

You need to start a new thread.

...........................

Did you use a helper column as i show to you?

1) In H4 you have this formula.

=SUMPRODUCT(($B$85:$B$95=G$83)*($E$85:$E$95=H$82&"")*($C$85:$C$95))

But G83 & H85 are empties....

2) SUMPRODUCT, does not like to calulate in a column MIXED nambers and text... So in column C, you must heve only numbers. Not words like "Names" or "Salesman" or ANYTHING. So delete these..

First of all, I would like to thank you for your help

second, I made like you told me, but the result now is equal to zero

1. Formula, =SUMPRODUCT(($B$2:$B$274=$K2)*($E$2:$E$274=H$3)*($C$2:$C$274))

2. I delete the salesman and name from column C

3. I changed column C format to Number

3. Result is 0

Is there is anything else should I do?

Unfortunately i am not able to see the last 2 posts, because of the forum problems.. I already mentioned this and wait to fix it...!

Replying to you in my last post the system "drives" me in the second page and i see the replies. Still not able to go in the second page clicking gust page 2 OR last page..

Any way see this one.

In H4 and copy down and across.

=SUMPRODUCT(($B$2:$B$95=$G4)*($E$2:$E$95=H$3)*($C$2:$C$95))

Didn't you see my attachment?

You need to study carefully the formula and modify it according your needs in your real worksheet.

I want to help you more but i don't see how can i do this any more..

Good luck.

You need to study the formula to understand how this works.

Probably to need some (range?) modifications in your real file.

As you mentioned, i try to help but anymore i can not understand how can i do this.

Good luck.