Collaborate on Shopping Bill in Excel for Personnel with Ease Using airSlate SignNow

Shopping bill in excel for Personnel

how can we sum per month and furthermore how can we add another criteria here basically to the left I have a data set about a sales report where I have date product sales quantity and uh the customer name basically I want you know how much I just sold for each one of the months that I have from January to December for example but despite of that I also want you know about the product so basically here I have two criteria two conditions the first one is the month and the second one is the product for example to do it we can use the equal sign sum ifs function because the sum ifs function allow us to use as many as criteria as we need to here I have two month and the product let's start doing the sum function here let me double click here in this function to select one two okay the first thing that the sum function is asking me is about the sum range what is the Su range that we need to use here as I want to know the total sold I need to select s the sum range the the sales column here so the column C for example I can click here okay now I can press comma and my next criteria here is going to be the criteria range number one for example first criteria range my first criteria range can be the month for example so I want to check uh all the dates that match with the January month for example because it's the first month that I have here January I can select here the First Column date but I actually have a problem here I know that I have the the complete date here so for example January 1st of 2024 okay I know that I have the month the date and also the year but how can I tell the sumith function that this date right there is actually January or I mean J for example how can I tell the Su function this I can't so before we do the Su Mis function we need to use another column to exract just a month from this date that we have and this is what you're going to do here so we're going to just ask here this function uh and in the column f for example I can click here equal sign now we're going to use the text function text double click here one two with the text function we can extract just the month from a date for example as the value I'm going to use the date itself comma I want to stract the month for example so we're going to open quotations M M M three times the letter M close quotations quote unquote close rences enter we done this is the month that corresponds that match with this date that we have here January if I just click here in the down right corner of the cell and drag down we can input this function to all the rows that we have here like this for example and we done September August July and so on so on now we can use the colum f as a criteria for example now we can come back here and do the equal sign Su IF function again now it's going to works the just double click here one two as the Su range as we just saw before is my column C the entire column C for example I can either select just a range like this or I can also click here in the C letter to select the entire column for example comma as my first criteria range I can select let's say the column F I can click here comma and because we select my first criteria range as the month I need to actually use the first criteria as the month to match okay so January I just clicking the sell tra now the sum function is asking me my second criteria range my second criteria range can be let's say the column B so I click here in this entire column B comma Now I can input here my second criteria that is going to be tablet for example but I can change so it's Dynamic I can also change to Smart TV or headphones or so on so on close parenthesis and just one more thing that we can do here before press enter this K3 cell right here that uh corresponds to my criteria here the product I need to actually click here in the selection and press F4 key to lock the reference because the way when we click in the down right corner of the cell hold and drag down this cell right here this range is going to stay in the same position it's going to lock the reference and this is what we need to do here so f for key to add the dollar sign before the letter and after the letter and then enter now I can click here in the down right corner of the cell and drag down like this for example and we done now we have the total sold per month and byproduct for example and I if I change here so let's say I'm going to use a laptop for example laptop enter as you guys can see the values are automatically upate for me so I hope you guys enjoyed this video some IF function with the help of the text function if you have any questions or any suggestions to the next videos let me know comment down below and I see you tomorrow as every has a new video I see you there