Countifs excel

Seamus2626
Seamus2626 used Ask the Experts™
on
Hi, i need the countif formula for

one if a number is >10 or it is greater than -10 eg -11

Thanks
Seamus
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT / Software Engineering Consultant
Top Expert 2016
Commented:
Try this, updating with your range in the formula.

=SUM(COUNTIFS(A2:A10,{">10","<-10"}))

Open in new window


»bp

Author

Commented:
Brilliant, thanks Bill!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial