•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I use subtotal along with sumif?
I was using sum on my sheet, but now I need to use subtotal so it can work along with the filter and manually hidden, example: "=SUBTOTAL(109;A2:A200", but I was also using "=SUMIF(A2:A200;"Approved";B2:B200) or sumifs for more than one condition, countif, etc. How can I use SUBTOTAL with thoses?
[link] [comments]
Want to read more?
Check out the full article on the original site