Advice on a few different formulas :)

Hello all -

This may be a quick solve for some of you, so I am reaching out for help. Basically (per the sheet attached), I am looking for solutions to:

1 - How can you write a formula to tell excel to ignore hidden rows when sorting. I have a a lot of possible data I would need to sort in a table. In doing so, when I pick and choose my data in the sort, my formulas still pick up all of the data. How can I resolve this in the formulas? (see row 30) - Please keep in mind that I have both COUNTIF formulas (L through R) and straight SUM formulas (U through X).

2 - I also have some quick database type charts set up (b36:g91)...is there any way for these #'s to quickly change as well per my table sorting (or should I just use a pivot table for this purpose??)

3 - in Column J, I am trying to simply extract the month (looks like I have done that), however, how do I get the blank cells not to show "January" - I just want a blank cell.




Thank you all!
Jeff

Question 3:

J4:

Formula:

Please Login or Register  to view this content.

Regards, TMS