# 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

#1
July 27, 2010 at 10:03:38
 Do you mean something like this?=SUMPRODUCT(--(A1:A10="Bob"),--(B1:B10="HR"),--(C1:C10="FT"),(D1:D10))If A7, B7 and C7 contain Bob, HR and FT respectively, the value in D7 will be returned.

Report •

#2
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 •

#3
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