Excel Help regarding formulas

[jpirtle]

I am trying to figure out 2 equations that I am stuck on.


Question 1:
I have a cell dedicated to the number of cars not cleaned (A91) and I want to pull data from a column of cells on the same spreadsheet that are labeled "# Cleans/month". The values of those cells (G79:G115) range from 0-4. I want cell (A91) to only show the number of cars not cleaned represented by 0. Is there a formula for that?


Question 2:
I have another cell dedicated to the number of cleanings past due for the cars (A94) and I want to pull data from a column of cells on the same spreadsheet that are labeled "Days since clean". The values of those cells (J79:J115) range from 0-120. I want cell (A94) to only show the number of cars past due on cleaning represented by numbers greater than 7. Is there a forumula for that?

Any help or suggestions would be greatly appreciated!

 

[gaz_chops]

Welcome to the forum.

Try

for zeros

=countif(G79:G115,0)

For >7

=countif(J79:J115,">7")

 

[Aladin Akyurek]

Try...

1.

=COUNTIFS(G79:G115,0)

2.

=COUNTIFS(J79:J115,">"&7)

 

[jpirtle]

Awesome! Thank you gaz_chops and Aladin Aykurek​. Those formulas worked great!

 

[gaz_chops]

You're welcome.