Help with VLOOKUP Formula

[tbruce]

Hi All,

Hoping someone could help me with a VLOOKUP formula. I'm trying to match the value of the cells in column E with the cell values in column A and C and if there is a match, add the values of their corresponding (neighboring columns) counts in column F. Here is a snippet of data. I've been working on the formula and can't seem to get it exactly right. Any help would be much appreciated.

A	B	C	D	E	F
Log #1	Log 1 Cnt	Log #2	Log #2 Cnt	Both Logs	Total Cnt
12112	432	13232	323	11111
13232	764	12112	112	12112
11111	25	12121	376	12121
12121	123	11111	324	13232

<tbody>
</tbody>

 

[Weazel]

maybe something like...

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F
1	Log #1	Log 1 Cnt	Log #2	Log #2 Cnt	Both Logs	Total Cnt
2	12112	432	13232	323	11111	349
3	13232	764	12112	112	12112	544
4	11111	25	12121	376	12121	499
5	12121	123	11111	324	13232	1087

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula F2 =SUMIF($A$2:$C$5,E2,$B$2:$D$5) <tbody> </tbody>

<tbody>
</tbody>

 

[tbruce]

Thanks - That worked, but I forgot to mention another value I need to produce and that is the value in Column E, where I need to look at column A and column C, and produce a list of all numbers from those two columns and enter in column E removing any duplicates. I can use the Remove Duplicates and paste, but was hoping for a formula to produce the numbers in column E.

 

[Weazel]

maybe something like...

=IFERROR(INDEX($A$2:$A$5,MATCH(0,INDEX(COUNTIF($E$1:E1,$A$2:$A$5),0),0)),"")