- 11
- 15 495
Joseph Cambron
Приєднався 8 лип 2022
How to use Google Sheets Sum(), Sumif(), Sumifs(), Average(), Averageif(), Averageifs()
This tutorial will show how to use Google Sheets =SUM(), =SUMIF(), =SUMIFS(), =AVERAGE(), =AVERAGEIF(), and =AVERAGEIFS() functions.
-- Affiliate Links --
If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
-- Affiliate Links --
If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Переглядів: 85
Відео
Google Sheets Data Validation Drop Down List and Checkbox
Переглядів 6942 роки тому
This tutorial will show you how to use all the data validations, including how to make drop down list that reference other tabs. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets Simple Formulas and Conditional Formatting
Переглядів 402 роки тому
This tutorial will show you how to make some simple formulas and conditional formatting. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets Conditional Formatting to find Duplicates & Triplets or more.
Переглядів 752 роки тому
In this Tutorial, I will show how to use conditional formatting to highlight duplicates and triplets or more. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets Conditional Formatting Entire Row
Переглядів 712 роки тому
In this tutorial, I will show you how to use Conditional Formatting to highlight the entire row in a table. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Pay Day To Pay Day Personal Budget
Переглядів 162 роки тому
Most budgets out there are month-to-month tools and that may work for you. Not for me. This is the budget tool that I built for my family. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets =Query() Multiple Tables
Переглядів 2,8 тис.2 роки тому
In this tutorial, I will show you how to query multiple tables. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets =Query() Sum & Count & Label
Переглядів 3 тис.2 роки тому
A short video that shows you how to use Sum, Count, and Label in your Queries. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets =Query Order By
Переглядів 2202 роки тому
A short video that shows you how to use Order By in your Queries. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets =Query() Group By and Order By
Переглядів 6 тис.2 роки тому
A short video that shows you how to use Group By and Order By in your Queries. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Google Sheets =Query() Contains & Or & And
Переглядів 2,2 тис.2 роки тому
A short video that shows you how to use Contains, Or, And in your Queries. Affiliate Links If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy.com/josephcambron
Nice video. Thank you
WORST CONTAIN WRITER LIKE ASS(GADHA)
THANK YOU!! Holy cow this was what i needed and thank you so VERY much for this video!!
Just what i needed. Thank you
Very helpful. Thank you.
Good job. I'd like to learn more about how to break out of the select string, come back into it, syntax issues, etc. For example, I get an error with this - =query({Eddie!$A1:$H25}, "select sum(Col2) where " & roundup(month( & "Col1" & )/3,0) & " = " & C$6 & " label sum(Col2) '' ", 0). I think my problem is I'm trying to pull Col1 into the month function. I already broke out of the string with the roundup function, but then I need to somehow come back in to reference Col 1 of my range. The roundup and month function together wouldn't work unless I broke out of the string.
Hello, Joe! Just discovered you. Excited to learn from you. I’m struggling to find a solution to my google sheet conflict and hoping maybe you can help…? 🙏🏼 I have an inventory dashboard tab I’m trying to build in a sheet and setup two query formulas to pull data into the dashboard from two other tabs of inventory. I’m I’ve got the two query formulas as a ={;}, which works fine by itself. But for some reason when I try to integrate drop-down menu filters to the dashboard query array, I can’t seem to get it to work and have also gotten the array literal error a few times. Can’t seem to find a solution.. is this something you might know how to resolve..? Thanks! - jared
Hi Jared. Thank you for the question. Here's what I want you to do. In your sheet go to File -> Make a Copy. Then in the copy delete all the tabs that are not a part of this question. Then remove all personal and confidential data. If that includes the items in your inventory please replace that with some dummy data that will replicate the real stuff. Then go to Insert -> Drawing and use the text box and place your question in there. You can reference cells where you need help and where data is coming from. Then share the link here. I'll make a video answering your question.
@@josephcambron8927 Hi, Joseph! I'm not sure if you received my comment with the link. I know sometimes a UA-cam account is set to not allow comments that include URLs... Let me know if you still need it or if I can directly send it via email or otherwise. Thank you!
I did not see your other post. Must be the url. Please email me at josephcambrontutorial at. gmail.com
@@josephcambron8927Got it! Thank you; just sent an email to you