# HLOOKUP - want to return sum of two consecutive values

#### jimharsh

##### New Member
I have an HLOOKUP formula which is working fine but there are a few instances where there are two consecutive records where I have an exact match and would like the formula to retrieve the sum of the two amounts. Currently, the formula only returns the first value. Any suggestions?

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
What does the current formula look like? - we'll tweak.

Here is the current formula: =HLOOKUP(\$A30,\$D\$4:\$DI\$81,69,FALSE)

perhaps:
=SUMPRODUCT((\$A30=\$D\$4:\$DI\$81)*(\$D\$72:\$DI\$72))
?

That worked! Thank you very much!!!

or how about a SUMIF .. if I am understanding correctly, then this should work

=SUMIF(D\$4:DI\$4,\$A30,D\$72:DI\$72)

@danzon - That worked as well....thanks!!!

Replies
3
Views
133
Replies
2
Views
199
Replies
10
Views
155
Replies
4
Views
183
Replies
10
Views
187

1,196,229
Messages
6,014,125
Members
441,802
Latest member
rhinab

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back