![]() Sum Sales if the salesperson is John OR Jim AND the region is North OR SouthĪrray Formula: Ģ. ![]() Whereas with an array formula you can do this: ![]() SUMIFS Formula: =SUMIFS(Sales,Sales_Person,"John", Region,"North") Sum Sales if the salesperson is John AND the region is North SUMIFS is limited to this type of criteria: Using the data in the table as an example the Knowing Excel array formulas will catapult you to ‘Guru Status’ in your office and I'll do my best to make this painless, but you might need to get a brainbooster (a fruit or veg snack given to the 5 year olds at my son's school at 10am each morning when they're starting to lose focus).Īrray formulas are ideal for summing or counting cells based on multiple criteria, a bit like SUMIF and SUMIFS, and COUNTIF and COUNTIFS but better, especially if you only have Excel 2003 and don’t have the *IFS functions.Īnd unlike the SUMIFS and COUNTIFS functions which only allow you to specify AND criteria, with array formulas you can specify OR criteria too. Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |