How to SUMIFS in Excel with Dates and with Multiple Criteria | Solving Real Problems

How to SUMIFS in Excel with Dates and with Multiple Criteria
In this Excel video tutorial, we gonna learn how to use the sumifs function in the Excel spreadsheet, formula sumifs, how to sum Excel dates with a criteria, excel expiration date, Excel expiry date alert, sales spreadsheet, inventory control worksheet, how to make the sum function in Excel with a practical example step by step with practical examples, free Excel tutorial, how to add in Excel only some values that meet a criterion, how to add in Excel only what is equal to a condition, sum formula with 1 criterion, sum with more than one criterion, in addition to several criteria in Excel, Excel tutorial to save time on a daily basis.
#JopaExcel #Dashboard #Excel

[@federicoandrademarambio2913]

Really helpful. I might even get control over my finances with these functions. Thank you!

[@originas8569]

Thank you !!!!

[@GlydelIsidto]

Extremely helpful and easy to understand

[@JopaExcel]

Gald it helped you! 🙏👍

[@maheramhaz]

I recently started using excel may I ask what is your advice how I should start and where I can find find material to practice

[@rehanakhatun5483]

I am Your new subscriber ❤ Vari vari thanks you sir

[@alecjulies2285]

Good day how can I create a performance apraisal scale with wording discriptions.

[@rehanakhatun5483]

Thank you sir ❤

[@JopaExcel]

Glad you like it 🙏👍

[@ahmadaimanbindahakimstaff2510]

You also can get the data using pivot? is it right sir? But I like this also..

[@JopaExcel]

Yes, you can. You can use PIVOT TABLES too. But the focus here is to use function, but why? Because, formulas have some benefits, such as always staying update whenever you have new values in the data set. Pivot table does not update on their own. In addition, by using functions, you have more flexibility when creating the design for your report or Dashboards.

[@ahmadaimanbindahakimstaff2510]

@@JopaExcel ok thank you.. i appreciate your answer. :)

[@Itsartee00]

I have an issue with the third condition on the "sumifs" function - I need to create a function to look at an expense category for a month, then a year and total it in a summary sheet against the respective months' column as a comparative table. Since there are multiple years, there is a problem, and the values result in zeros. It works well with two conditions and reflects the values, but the third condition results in zero values. My table should pick the year from a drop-down cell marked as a constant. =SUMIFS(Table1[Debit],Table1[Category],'Annual Summary'!$B4,Table1[Month],'Annual Summary'!$C$2,Table1[Year],'Annual Summary'!$T$3) is the formula used. Can you help me in correcting the error?