Filtering Data

[spookykid]

I created these formulas on a separate sheet and I need help with changing it so when the source sheet is filtered it only shows what is filtered and not all the data, any help would be greatly appreciated!

=SUMIFS(OT_COMP!I2:I1048576,OT_COMP!B2:B1048576,"OT",OT_COMP!E2:E1048576,"Place Holder")

=SUMIFS(OT_COMP!I2:I1048576,OT_COMP!B2:B1048576,"OT",OT_COMP!E2:E1048576,"Place Holder",OT_COMP!C2:C1048576,"180")

 

[DanteAmor]

Re: Help With Filtering Data

Try



If it is a numerical value
=SUMPRODUCT(SUBTOTAL(9,OFFSET(OT_COMP!$I$2,ROW(OT_COMP!$I$2:$I$8000)-ROW(OT_COMP!$I$2),,1))*(OT_COMP!$B$2:$B$8000="OT")*(OT_COMP!$E$2:E8000="Place Holder")*(OT_COMP!C2:C8000<>180))


if it is text
=SUMPRODUCT(SUBTOTAL(9,OFFSET(OT_COMP!$I$2,ROW(OT_COMP!$I$2:$I$8000)-ROW(OT_COMP!$I$2),,1))*(OT_COMP!$B$2:$B$8000="OT")*(OT_COMP!$E$2:E8000="Place Holder")*(OT_COMP!C2:C8000<>"180"))

 

[spookykid]

Re: Help With Filtering Data

I figured it out shortly after I posted, thanks so much guys!

 

[DanteAmor]

Re: Help With Filtering Data

Your welcome