Get instant live expert help to figure out how to use COUNTIF function in Google Sheets

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i need to add a MAX function to change the following formula to output "0" if the result is a negative number. Any ideas? (fyi this is a google sheets formulas, not written in excel) =ARRAY_CONSTRAIN(ARRAYFORMULA(IFERROR(IF(COUNTIF('Battle Points'!$F$2:$F$81,$L25),$M25-INDEX('Battle Points'!$K$2:$K$81, MATCH($L25,'Battle Points'!$F$2:$F$81,0)),"No Data"),"No Data")), 1, 1)
Solved by K. E. in 22 mins
Hey, If i have a cell range for foreg: a1:a100 and b1:b100 and i want to know if a1+b1=7 for each row and get the countif value that total 26 cells return with a total of 7. How can i get that done in excel or google sheets. I have tried the countif and cointifs command with multiple columns but don't know how to get them to add/substract with each other. Thanks.
Solved by B. W. in 22 mins