SUMIFS Google Sheets | Multiple criteria on columns

In this video, you will learn how to use Sumifs basics using Google Sheets. You also learn how to do sumifs using multiple with multiple criteria and columns.
00:00 Introduction
00:15 Single Criteria Sumif
03:16 Multiple Criteria Sumifs
Link to the Google Sheet - docs.google.com/spreadsheets/...
#sumifs #googlesheets

[@lholhofox]

Thank you for the video Sir!! Keep'em coming!!

[@fotis7299]

THANK YOU!

[@kqxx]

Is it possible to create sumifs for categories (in this example it would be site 1) in a date range?

[@alikhan110786]

Hi kunaal, I have a difficult calculation can you please help me on this. In this calculation I want to sum amount if it’s been spent on same purpose by different persons. Spent reason and names are in two different columns. For example column A contains names like Raj, Mohit, Amir, etc & column B contains amounts and column C contains different spent reasons and my query is to sum the spent of a particular reason made by all of the persons names mentioned in column A

[@juanfernandomoyanoramirez600]

Thanks for this video, it was very useful

[@KunaalNaik]

Glad it was helpful!

[@ShubhankarDaptare]

Hello Kunal, Thank you for this video. I have a query, 'I want to calculate some negative numbers from a column that have some positive numbers also using SUMIFS' can you help me?

[@KunaalNaik]

Yes, can you send me the data to [e-mail]

[@sophyrath9299]

thanks for the video! Could you hep me, please? if I want to SUM {Mobile and Web} between date {1st Jan 2021 and 31 Jan 2021} and Site1

[@findingtina7967]

Hi there! Great video! I do have a question. Can sumifs be used with a date in place of the text? I am an accountant that reconciles accounts on a daily basis. I am trying to create a a formula that will give me my balance based off of a date that I enter. I also have a query that runs my dashboard. So all of the balances on this page are there because of the query. I am not sure if any of that makes a difference as I am new to google sheets and trying to learn it. Thank you in advance for your help!

[@KunaalNaik]

It can be used. Ensure the date is in a "date format". If you can send me a sample, I can show you how to create it. send to [e-mail]

[@findingtina7967]

@@KunaalNaik thank you so much. I will email it over in a bit.

[@gemijuine]

Thanks for this! But it doesnt seem to work when SUMIFS are in single column. Say I have Sites 1 - 5 and I want the sum of only Site 1 and 2. This formula: =SUMIFS(sum_range, range_col_A, "Site 1", range_colA, "Site 2") does not work. :( I had to do the sum of two sumif for this. Please let me know your suggestions?

[@KunaalNaik]

Unfortunately, it gets tricky with 2 Criteria. You are doing it the right way. The other way is using Sumproduct, which is more complicated. Check this article for more - www.ablebits.com/office-addins-blog/2018/03/21/sumifs-google-sheets/#:~:text=SUMIF%20with%20OR%20criterion%20(multiple,add%20two%20SUMIF%20functions%20together.

[@lavicrep07]

Hi Kunal, may I ask how can I make a formula for multiple criteria that has a constant value. For example, AB = 1 AC = 2 AD = 3 Day Jan 1 AB 2 AD 3 AB 4 5 AC How can I get the sum of this for the month of Jan?

[@MiguelReyesDeveloper]

Thank you so much.

[@KunaalNaik]

You're welcome!

[@manikandanc7286]

Hi Can you guide sumifs with importrange formula, I have tried many times its seems error, Please help on this

[@ubaidillahmuhammad20]

nice and good job. please put all excel practiced files in the description....

[@KunaalNaik]

Thank You. I have placed the link in the description section - docs.google.com/spreadsheets/d/1AtWoNgK1hPJs0vmcryuXXNnjAz_Ny-Wm-cqbJ89pwKY/edit?usp=sharing

[@jaicengg]

सर 1:08 से 1:11 के बीच में आप रेंज फिक्स कैसे किये? वो पार्ट समझ नहीं आया। प्लीज क्लियर कर दीजिये 🙏🙏🙏

[@matematiksel]

can i ask a question about sumifs? i write "

[@matematiksel]

i find it. it must be use "

[@KunaalNaik]

I am glad you got it!

[@rolandv8121]

Hello Kunal, Thank you for this video!! Can you help my whit formula? I not get it working.

[@KunaalNaik]

You are welcome! How can I help?

[@rolandv8121]

@@KunaalNaik I send you email i am so happy that you want to help my out!!!

[@eunimini2096]

I want to get sum of both Yes and N/A but I get 0 as result. I followed you and this is my formula: =SUMIFS(E3:T3,E5:T5,"Yes",E5:T5,"N/A)

[@mudassar1]

D1:D22 B1:B22 "Site1" D1:D22 "Mobile" what to sum | Criteria1 - look in Criteria1 - look what | Criteria2 - look in Criteria2 - look what