✔️ Learn to use nested functions and optimize the calculation, SUM in different ways and choose the one that best suits you
In this tutorial we are going to see 3 ways to make a summation by the Year criterion, we will be nesting functions, since we do not have a function that does that objective we must use ingenuity to solve the problem, we are going to see the classic SUMAR.IF function .SET nesting with the DATE function, SUM function, enhanced with a conditional and finally the SUM.PRODUCT function, a seldom used gem.
#LoganExcel #Years #Sum #Excel #SumProduct
🔴 Subscribe 👉 / @loganexcel
📃 Download File
📌Related Videos
✅ INDEX MATCH function • Función INDICE COINCID...
✅ Dynamic Dropdown List • ✅ Lista Desplegable di...
Also follow me on my Networks 📲:
🔹Facebook / logan-excel-1008353283...
🔹Blog loganexcel.wordpress.com/
🔹Instagram instagram.com/loganexcel/...
Негізгі бет 😱 3 ways to SUM by year in Excel, SUM, SUM.IF.SET, SUM.PRODUCT
Пікірлер: 8