Hi
try the following:
=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($A$1:$A$10,1,1),ROW($A$1: $A$10)-
ROW(INDEX($A$1:$A$10,1,1)),0))=1),--($A$1:$A$10="lookup_value"),$B$1:$B
$10)

looks for the value 'lookup_value' in column A and sums the
corresponding value in column B


--
Regards
Frank Kabel
Frankfurt, Germany


Dilip Mistry wrote:
Hi

Has anyone created a macro that uses the functionality of the
SUBTOTAL with the functionality of the SUMIF.

I am trying to sum only visible cells using a selection criteria.

Thanks in Advance