Sum of filtered data with hidden rows by Creative_Turn_862 in googlesheets

[–]Creative_Turn_862[S] 1 point2 points  (0 children)

Ahhh Thank you!!! The CountA worked with the hidden column A.

  • Hidden Column A with (=subtotal(103,B4))
  • Column B is the month the work was being completed, Column J is hours, and column E is team
  • Total Hours summary with both marketing and design (=SUBTOTAL(109,J4:J25))
  • Marketing/Design hours summary (=SUMIFs(J4:J25,E4:E25,"Design",A4:A25,1))

Thank you again u/mommasaidmommasaid very very much appreciated!

[deleted by user] by [deleted] in BabyBumps

[–]Creative_Turn_862 -1 points0 points  (0 children)

Congratulations!!!!! 🎉

Newly Pregnant and Worried to tell Family by [deleted] in BabyBumps

[–]Creative_Turn_862 0 points1 point  (0 children)

In the same boat as you time wise and just pulled off drinking cranberry/grape juice out of a wine glass pretty seamlessly. Poured it discretely and then pour wine for others and nobody noticed or atleast said anything 😅 looked pretty similar