Return value if two data points match
I want to return a value when two data points match.
For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
Return value if two data points match
Hi,
let's assume that you enter Commitee in D1 and June in E1 and want the result in column F1 =sumproduct(--(D1=$A$1:$A$1000),--(E1=$B$1:$B$1000),$C$1:$C$1000) if this helps please click yes thanks "ptf" wrote: I want to return a value when two data points match. For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
Return value if two data points match
Use:
=SUM((A1:A2="Committee")*(B1:B2="June")*(C1:C2) but after you've typed it use Ctrl + Shift + Enter rather than just Enter. Sam "ptf" wrote: I want to return a value when two data points match. For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
Return value if two data points match
=SUM((A1:A2="Committee")*(B1:B2="June")*(C1:C2))
(Bracket missing...) "ptf" wrote: I want to return a value when two data points match. For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com