sumifs filtered data

[av8tordude]

the wb attached is currently filtered. Column K indicates the status of the position. In cell T15, i would like to know the total amount of all filtered data for positions that are currently open. Vice versa I would like to do the same for all filtered data currently closed.

Can someone assist with a vba code or formula. Thanks

[paulked]

What happened to this (http://www.vbaexpress.com/forum/showthread.php?67170-Combine-countifs-amp-Subtotal&p=401033#post401033)?

[av8tordude]

What happened to this (http://www.vbaexpress.com/forum/showthread.php?67170-Combine-countifs-amp-Subtotal&p=401033#post401033)?

Previously, I asked to count, however, i want to sum the total. The code below does this if cell T11 is filled, however, if want to know the total of the filtered information without T11 being filled, it gives me zero.

here's the code...


Range("T14") = Format(WorksheetFunction.SumIfs(Range("J7:J" & LRow), Range("A7:A" & LRow), Range("t11"), Range("K7:K" & LRow), ""), "$0.00")

[Bob Phillips]

Says the file is corrupted when I try to iopen it.

[Paul_Hossler]

I can open the XLSM, but there are no macros in it