•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
Tagged with
#financial modeling with spreadsheets
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#subtotal
#sumif
#sumifs
#countif
#filter
#manually hidden
#A2:A200
#B2:B200
#approved
#sheet
#conditional
#Excel
#function