Conditional SUM in Excel

to find the sum of values against all those words that start with the text t-shirt in other words to find the total number of t-shirts from this table in the formula bar equal sum if function open parenthesis first argument range select the cells containing items comma second argument criteria t-shirt is our criteria double quotes t-shirt asterisk double quotes comma third argument sum range select the cells containing numbers enter and we have the total number of t-shirts

Channel: Ajay Anand

Views: 195,381

Keywords: XL n CAD, XLnCAD, Excel, MS Excel, Excel Tricks, Excel Tips, Learn Excel, Excel for Beginners, Excel Tutorial, Programming in Excel, Excel Programming, Excel VBA, Learn VBA, Macro, Excel Macro, VBA Macro, Excel Shortcuts

Id: lbmH_A5-AXg

Length: 0min 36sec (36 seconds)

Published: Tue Jan 04 2022