How to sum values based on month and year in Excel
Вставка
- Опубліковано 25 сер 2024
- Hello I Am Balram Singh Welcome To Our UA-cam Channel AIO Digital Institute.
About Video
1. SUMIFS function adds values that meet single or multiple criteria. Ability to use criteria with logical operators like - grater den equal and less den equal provides the way of adding values between values like sum month.
How to Apply Formula
=SUMIFS(sum data range,date range,"grater den equal" & first day of month,date range,"less den equal"&EOMONTH(first day of month)
2. Displaying a month like 01/01/2020 is not ideal. Thanks to formatting options of Excel, we can display a date by its full month name. Adding custom format "mmmm" to a date displays it by its long month name without changing its original value. To apply a custom format: "mmmm"
Download Practice File Link-
drive.google.c...
#sumdatabymonth #excelinhindi #sumifsfunction
Aio Digital Institute Mobile App Link -
tqmmvv.on-app....
Contact
Email - aiodigitalinstitute@gmail.com
Thanks a lot bhai me pareshyan tha ye kase karenge apne diya solution
Thanks sir 👍
Thanks a lot, Very Useful Trick
Thanks brother
Quite useful for me
So usefull.... Thank you so much 👍
Thank you. your suggestion solved my problem.
Thank you
Simply super bro... You made my day thank you
So nice of you
Thank you sir ji
So nice of you
Thanks alot Bro
Thanks brother 👍👍👍👍
Great video brother
Thanks for the visit
thanks it's working
Thank you 😊
Thanks bro
very well. oh
How to combine month & year together ?
Rest well explained 👍🙏
Please on video weekly report
Sir Muje Apase Shikhna He Formula
Very nice 👍👍
Thank you 👍
Hi, good job, but what i am need is not same, but what i need is not being found anywhere, can u help me ?
agar multiple client ka month with nikalna ga diffrenct name wise
Please send me workbook official email aiodigitalinstitute@gmail.com
Sir quarter and half yearly sum ho sakta hai kya sir
Your problems next video main solve
Ye Kam nahi kar Rahi error aa aa rahi he #name? Valu not working in ms 2021 excel
Please send excel workbook official email. aiodigitalinstitute@gmail.com
Aayse Monthly loss and profit nikala he pls formula
Wait for 2 days
sir week wise kaise lein?
Thanks !
Srishti Mathur Visiting my You Tube Channel
Our Next Video Your Problem Solve.
financial year wise sumif function batAVE
Your month formula not working
ua-cam.com/video/efAqXbQZDbA/v-deo.html
Agar ek ki date ko 2 payment aate hai to unka total kese kare
Use Function =Sumif(Date Rang, Criteria Date , Sum Rang)
@@AIODigitalInstitute thanks brother
Ek problam aur hai google sheet me due date ka formula lgate hai to error me value show ho rha hai
@@AIODigitalInstitute google sheet me date format dd/mm/yy karta hu to formula glt ho jata hai aur mm/dd/yy. karta hu to formula shi ho jata hai
@@rajasthanib4u406 Please send me Workbook official email - aiodigitalinstitute@gmail.com