can i use subtotal like sumif

S

SHARIQWAQAR

is there a way to use subtotal in filtered list adding up alternate row
or
rows with some same key like in sumi
 
F

Frank Kabel

Hi
try:
=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),--($B$1:$B$10="text"))

for summing all visible rows which contain 'text' in column B
 
Top