sumproduct variables are true

Microsoft Excel 2003 (full product)
July 27, 2010 at 09:06:06
Specs: Windows XP
I need to have the cells that i have defined in the sumproduct equation. If the variables are all true i need the result to display data that is in a specific cell. For example:
If the criteria that i have specified in the sumproduct function is all "true" then in the function cell i need it to display the data from a sites column not the amount that fit the criteria.

Don't know if I'm explaining this well enough please let me know if i can provide more info.
You all rock on this site and I thank you.

See More: sumproduct variables are true

Report •

July 27, 2010 at 10:03:38
Do you mean something like this?


If A7, B7 and C7 contain Bob, HR and FT respectively, the value in D7 will be returned.

Report •

July 27, 2010 at 10:25:11
Is it possible to have it display the text that is in the "D" Column as the result?

Report •

July 27, 2010 at 10:51:52
Yes, there are ways to do that (see the discussion here) but I have another suggestion. (also mentioned at that site)

Based on my example of Columns A:D, could you insert a new Column A and concatenate the B:D (the old Columns A:C) values and then use VLOOKUP to find the concatenated string and return the value from Column E (the old Column D)?

Report •

Related Solutions

Ask Question