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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Sumifs with Subtotal 0
mixing SumIf and Subtotal Functions 4
subtotal with sumif nested 1
Macro Pause to Select range then Subtotal 0
Changing my functions to use subtotals? 6
SUBTOTAL and COUNTIF (or SUMIF) combination 2
VBA word change keys 0
Can I use the subtotal function while a worksheet is protected? 0

Top