How to Sum per Month in Excel and add more criteria like Product, Customer etc | Sumifs function

[@deeckl]

After watching 4 confusing videos, this is the BEST ONE!!!! Thanks soooooooo much

[@JopaExcel]

Thank you. Great to hear that! 🙏👍

[@tekuyung69]

The most simple and straight to the point video!

[@cinnamonbunnyy]

Thanks so much for this! I was given a take home assessment for this job application and this helped a ton as someone who's always been intimidated by Excel formulas!!

[@jaspreetjohl5250]

OMG!! so you may have noticed I have commented a few times on your videos as im trying your method AND IT WORKED!!!! thank you so much for your tutorial!!!

[@JopaExcel]

I'm happy to help. 🙏👍 And, yes, I did see your comments. Thanks for the feedback. Glad to help!

[@Historytimeline270]

Very useful video. I have benefited a lot. May Allah reward you well Ameen Ya Allah

[@Nieldyboy]

You deserve an award for this. Thank you!

[@ryantubehd9392]

Thank you sooooo, sooooo much. I spent 2 hrs last night trying to work this out and this morning, your's was the first video I looked at and it worked immediately. Thank you so much for sharing you knowledge. I've subscribed too :)

[@JopaExcel]

Ryan, thanks for the feedback. Glad it was useful! 🙏👍 Now, instead of spending 2 hours, you will only spend 5 minutes. SUMIF is the best

[@paulemmanueligubor3202]

Very Helpful especially in dealing with the dates. Thanks

[@Icy_Igloo]

Thank you. Great simple explanation.

[@neil9768]

Thanks

[@JopaExcel]

You're welcome, Neil! And thank you for the donation. 🙏👍

[@shashaa.s.5146]

Very helpful! ❤

[@JopaExcel]

Glad it was helpful!🙏👍

[@abbaaminu6003]

Thanks great video 🎉

[@guelphmortgagebroker]

Thanks! This was helpful.

[@JopaExcel]

Glad it helped! 🙏👍

[@jemilanurudeen5258]

This is what I want but I don't want the months to be listed like that, I want it to be a drop-down list (data validation). Can I still use the "sumifs" function for it?

[@yousafoilmills3787]

excellent

[@akashcnakod1017]

Thank you it solved the issue

[@Hari-n4f]

Can't we use text function directly in the formula i.o. helper column~?

[@Booster_pack]

Is there a way without converting to text? Like but the entire thing into one formula

[@MKay-xt9cu]

hi. may i know what if i want the criteria range to include the year as well? for example for feb 2022 and march 2023 what are the total $?

[@gtiw7]

Refer to the video at 2:44 - instead of "mmm" you should type "mmm"&" "&"yyyy" then it will show the year as well in the criteria range.

[@MKay-xt9cu]

@@gtiw7 thanks for the reply. okay ill try it later!

[@Booster_pack]

Can you also do it with the month and year? Like instead of Jan can I make it Jan-2024 cos my data set runs from 2022-2024 i dont want it to sum both year’s jan

[@udhayakumark2772]

Thank you so much Dear

[@abhilashs4179]

Hi, how to find sum of particular items eg. tablet between dates e.g from jan to feb

[@RituKS-pics]

If I wanted to calculate data for a particular product twice a month (1st and the 15th), what other criteria can I add?

[@stevenparker3952]

How would I for example calculate the cost of staff travelling & hotel costs, broken down by their names and then the month? Is the principle the same?

[@khammonthsybounheung]

thanks

[@Nieldyboy]

Do you know how to, say, if I had multiple figures in a Month? Some Pluss and some Minus, how can I have two separate columns with the total of the minus and a total of the positive?

[@NotDimpsy]

How do I accomplish that without adding the column for month?

[@najmulhasan3519]

It was nice, but when year change how get specific year data?

[@JopaExcel]

In the same way that we have a column in our table with the months of each of the dates, we also need to have a column in our table that extracts the year from the dates (you can use "YYY"). Now, we can use one more criteria in the SUMIFS function, in this case, the year. Anyhow, I gonna make a video about this subject. Add up values per Days, Months and Years.

[@mr.gk5]

Can you just go to cell format, custom and change the date format to mmm? I think it'd be much faster

[@touchoflight877]

How to solve by placing the product in place of the month and the product in the place of the month? Please help

[@Nexcw]

what to do when we have more columns of date..

[@CaptainNaingMyoZaw]

Thank sir

[@JopaExcel]

Glad it was useful. Thank you 🙏👍

[@maheramhaz]

i have only as date as a criteria, in spite of following the steps still receiving 0 value

[@toyosiabayomi326]

Thank you

[@JopaExcel]

I'm glad you liked it! Thank you 🙏👍

[@larryrower5172]

I have followed all of these steps perfectly and all I return is a zero.

[@cst021pavithrat6]

I too get zero. what to do? Have you solved?

[@jennifercatubay]

How to make formula using excel below 50000 =250 , above 50000=400

[@mohammedtharwat3132]

Use if formula, or ifs, ifs(A1"50000","400"

[@NicasioPineda]

Thanks