MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Culling Sales from a list

Posted by John Ridd on December 21, 2001 10:55 AM

I am working with a large number of home sales arranged chronologically. I wish to cull particular sales from the statistical summary. These sales need to be reviewed later. "Hiding" the sale does not remove its value from the ratio summary. Deleting the sale will leave me later wondering what I left out. I have tried "lists" with no luck. Would I be able to use "checkboxes" to remove a value in a row while retaining the sale as a placeholder.

Posted by Scott on December 21, 2001 11:47 AM

If you use Auto Filter to filter out the numbers that you don't want to see, you can then use the "=Subtotal()" formula to sum, avg, etc the remaining numbers. Within the formula, you use a Function Number (1-9) to tell it what to do. Example: =subtotal(1,A1:A100) This would average this range, =subtotal(9,A1:A100) This would sum the rage.

Hope this helps.

Posted by JR on December 22, 2001 5:45 AM

Thank You Scott -Will Try the Suggestion