How to use SUBTOTAL Function in Excel | @Learnwithvirendrakumar

How to use SUBTOTAL Function in Excel To use the SUBTOTAL function in Excel, follow these steps: Here are some common function_num values for different calculations: 1: AVERAGE 2: COUNT 3: COUNTA (counts non-blank cells) 4: MAX 5: MIN 6: PRODUCT 7: STDEV.P (standard deviation for a population) 8: STDEV.S (standard deviation for a sample) 9: SUM 10: VAR.P (variance for a population) 11: VAR.S (variance for a sample) For example, if you want to calculate the sum of a range of numbers (including hidden values), you would use =SUBTOTAL(9, A1:A10), where 9 represents the SUM function. The SUBTOTAL function is particularly useful when you have filtered data because it can perform calculations on both visible and hidden rows, depending on the function_num you specify. #ExcelFunctions #ExcelTips #SpreadsheetCalculations #DataAnalysis #MicrosoftExcel #ExcelTutorials #ExcelFormulas #SUBTOTALFunction #ExcelMastery #DataManipulation #excel #exceltips #microsoft #interviewtips #advanc #vlookup #vlookupformula #choose #choosefun #exceltips #exceltutorial #exceltricks #excercise #excelformula #excelformulas #mis #microsoft365 #microsoftexcel #microsoftoffice #microsoftteam #exceltutorialforbeginners #exceltipsandtricks #serial #serialnumbers

Видео How to use SUBTOTAL Function in Excel | @Learnwithvirendrakumar автора Успешный бизнес с Excel