•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?
Our take
To effectively use SUBTOTAL alongside SUMIF in your spreadsheet, understanding their unique functionalities is essential. SUBTOTAL allows you to perform calculations while considering filtered and manually hidden rows, making it ideal for dynamic data analysis. For instance, you can incorporate SUBTOTAL within your SUMIF formula by using the appropriate function number, such as 109, which sums only visible rows. This approach enables you to maintain conditional calculations while adapting to changes in your data view, ensuring accurate insights even as you filter or hide information.
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]
Read on the original site
Open the publisher's page for the full experience
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