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
What happened to this?
Semper in excretia sumus; solum profundum variat.
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.Originally Posted by paulked
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")
Says the file is corrupted when I try to iopen it.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I can open the XLSM, but there are no macros in it
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
