| Home > Forum Home > Managing Supply Chain and Inventory > Help calculating delivery performance > SUMIFS and COUNTIFS | Share |
SUMIFS and COUNTIFS
Excel Help for Sumifs And Countifs in Managing Supply Chain and Inventory
| Forum Topic | Login |
Sumifs And Countifs | Rate this: (3/5 from 1 vote) |
 |
You can aggregate data from multiple columns using SUMIFS on and COUNTIFs to get averages for the multiple critieria. Putting the data into a data table with filters and sort can help to rank. Also PERCENTILE function can help to calculate top percentile values from the data. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for SUMIFS and COUNTIFS in the Excel Business Solutions Directory |