![]() You can also use a named range in the SUMIFS function. Result: 18.85 'Uses the ? wildcard to match on a single character, ie: Bananas, Benanas, Binanas, Bonanas, and so on Using Named Ranges Result: 18.85 'Uses the * wildcard to match on all products that start with B Let's look at some Excel SUMIFS function examples and explore how to use the SUMIFS function as a worksheet function in Microsoft Excel:īased on the Excel spreadsheet above, the following SUMIFS examples would return: =SUMIFS(C2:C9,A2:A9,"=2013")
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |