do 2 criteria search in column and 1 criteria search in column

[cyncynangel]

Hi there

I would like to do 2 criteria search in column and 1 criteria search in column. How should my formula be?

For example:

Product: CDE has two manager (RTF and RGIL)

I would like to first lookup product (CDE) then manager (RTF) then the month (April-19) for the income amount. (See attached worksheet)

Prefer not to have array

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[AliGW]

Where and how do you want the result data to be presented?

[cyncynangel]

Any field is fine.

I just need to work out the formula how to get the final number

If I want Product: CDE -> Manager: RTF - Month: November-19, i should see "5.00"

[cyncynangel]

sorry about that and i will have a read

[AliGW]

Try this:

Excel 2016 (Windows) 32 bit

	A	B
16	Product:	CDE
17	Manager:	RTF
18	Month:	November-19
19
20	Result:	5

Sheet: ???

In B20:

=SUMPRODUCT(($A$5:$A$10=B16)*($B$5:$B$10=B17)*($G$3:$O$3=B18),$G$5:$O$10)

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.