I am Using the SumProduct function to sum the visible contents of a datatable that gets data from access. this function



=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($H$12:$H$50098,1,1),ROW($ H$12:$H$50098)-ROW(INDEX($H$12:$H$50098,1,1)),0))=1),--($I$12:$I$50098="1310"), $H$12:$H$50098)

works

but

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($H$12:$H$50098,1,1),ROW($ H$12:$H$50098)-ROW(INDEX($H$12:$H$50098,1,1)),0))=1),--($I$12:$I$50098=A6), $H$12:$H$50098)

does not. Even though A6 = 1310.

Can anyone explain why this may occur?

"1310" is a text string, while 1310 is a number. Get rid of the double quotes in the 1st formula, that should do

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post