HLOOKUP - want to return sum of two consecutive values

[jimharsh]

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?

 

[p45cal]

What does the current formula look like? - we'll tweak.

 

[jimharsh]

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

 

[p45cal]

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

 

[jimharsh]

That worked! Thank you very much!!!

 

[danzon]

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

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

 

[jimharsh]

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