B BigD Member Oct 6, 2014 #1 It drives me bananas when I cannot figure something out. I am trying to make the sheet calculate the day total based upon filtering the "supervisor" column. Thank you for any help. Attachments Schedule 10.27.14_Dustin.xlsm 473.1 KB · Views: 4
It drives me bananas when I cannot figure something out. I am trying to make the sheet calculate the day total based upon filtering the "supervisor" column. Thank you for any help.
Luke M Excel Ninja Staff member Oct 6, 2014 #2 SUM doesn't care if a cell is hidden or not. You'll want to use the SUBTOTAL function, which can ignore hidden cells. Instead of this structure: =SUM(MyRange) you'll want: =SUBTOTAL(109,MyRange) CHeck out the XL help file on SUBTOTAL for more info.
SUM doesn't care if a cell is hidden or not. You'll want to use the SUBTOTAL function, which can ignore hidden cells. Instead of this structure: =SUM(MyRange) you'll want: =SUBTOTAL(109,MyRange) CHeck out the XL help file on SUBTOTAL for more info.
B BigD Member Oct 6, 2014 #3 worked like a charm. Thank you, Luke. You save me from pulling my hair out.
Mike H.. Active Member Oct 6, 2014 #4 BigD said: It drives me bananas when I cannot figure something out. I am trying to make the sheet calculate the day total based upon filtering the "supervisor" column. Thank you for any help. Click to expand... Hi, I changed your formula to this which ignores rows filtered out, =SUBTOTAL(9,Table4[Mon, 10/27]) Attachments Schedule 10.27.14_Dustin.xlsm 390.4 KB · Views: 3
BigD said: It drives me bananas when I cannot figure something out. I am trying to make the sheet calculate the day total based upon filtering the "supervisor" column. Thank you for any help. Click to expand... Hi, I changed your formula to this which ignores rows filtered out, =SUBTOTAL(9,Table4[Mon, 10/27])
