we are going to talk about countif and countifs so on this sheet we have with sales
for a firm and beside the name we have the
salesperson people that are responsible for these sales and here we have the
billing date now what would you like to do is we would like to count how many of
these sales were billed before the 15th July so what we're going to do is we're
going to go equals and we're gonna go count if now let's
select the range so that the range that we're gonna press Ctrl Shift down errol that will select our entire
range so now we're gonna put in a comma here
now we would like this to be less than or equal to the date and so what we're
gonna do is we're going to put in quotation marks less than or equal we are going to end
the quotation marks a little space in here and then we're going to select
this date here now we don't want the actual day we wanted to be less than the
value of the date so let's put in and sign so it will give you the
value of this date and then we put a closing bracket on this and we will have
a result there we have we have 18 sales for every sales people person here that
he has been billed before it before equal to the 15th so now we would like to add
in another piece of criteria on to our counting function so what we're gon na do
is we're going to select the cell next to the eighteen and we're going to go equals
and countifs then what we'll do is we will do the same criteria as
use we did the last one so we're going to select this range and I'm gonna put a
comma and a quotation mark and we're gonna go less than or equal to and then we're gonna
end of quotation marks and then we will put a space
and then we're going to select the date here once again we wanted to be the
value of the dates were gonna put the and sign in front of it
oK so that's our first criteria so we're gonna put a comma here and now let's let
the second range we're going to select the range where the sales people are
and we're gonna put a comma in there and we're going to select the name of the
salesperson that we want which is John and so we're going to close our bracket
and we're gonna press Enter
so here you see with the countifs we have determined that in sales were made by
John were billed before or equal to the 15th so that is the count if and the
countifs function