hi:hello

[c14]

Hi..

Problem:
column A has dates in m/d/yyyy format. iam applying auto filter on A
and counting each of the filtered rows.

I wanted the sum of column B(contains nos) filtered rows.. in to some other column.

suppose my filterd result contains 7 values. i want the sum of all 7 values of colum B.
next time filtered result may contain 15 values. i want the sum of all 15 values of colum B.
iam using the SUBTOTAL macro code to get the result. but failing...

i need macro code.

ActiveSheet.Range("$k$1:$k$" & iRow).AutoFilter Field:=1, Criteria1:= _ (((( Auto filter here)))
"<=" & Cell_a_value

RangeToCount = "T51:T999" & iRow
On Error Resume Next
VisibleRows = Range(RangeToCount).SpecialCells(xlCellVisible).count (((( Counting the filtered rows))))


i need code for sum of the filtered rows.


help..

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[royUK]

And edit to add code tags