User Profile
hostetter4u
Copper Contributor
Joined Mar 27, 2022
User Widgets
Recent Discussions
Adding function to Formula
I have used the following formular which works however I need to add a second criteria and this is where I have issues. I have selected the column than I have the two dates below so that I can change them to get the data I want (B125 and B126) and I want it to tell me how many with those dates had Saturday. However I want to expand this to a certain neighborhood and I cant figure it out. =COUNTIFS(Sheet1!C3:C400,">="&Sheet2!B125,Sheet1!C3:C400,"<="&Sheet2!B126,Sheet1!E3:E400,"Saturday") Example: Currently, I have 10 rows of information Neighborhood, Date, Day of Week, and the game they played. I created a cell so that I can change the dates and just look at 1/15/22 to 1/22/22 if I want without having to change my formula. I know how many participated between the dates on Saturday(above formula) total but I want to now see how many participated on Saturday that lived on House Lane. Hope this makes sense.1.3KViews0likes1Comment
Recent Blog Articles
No content to show