• 461K Members
• 5,190 Online
• 559K Conversations

New Contributor

COUNTIF function

I am trying to use the following COUNTIF formula
=countif(\$f\$7:\$aj\$7,”(f7/f6)>.95”)
I am not getting a result and can’t figure out why. If I use the evaluate function it functions properly up until the result. Please help.
5 Replies

Re: COUNTIF function

With that function you compare each cell of your range with the text in second parameter. I guess no such texts in the range, result shall be zero.

You may use

`=SUMPRODUCT( --(\$F\$7:\$AJ\$7/\$F\$6:\$AJ\$6>0.95))`

if there are no blank cells in row 6.

Re: COUNTIF function

What I am trying to do with the function is compare efficiencies by day. If the production line produces 95% or high of the plan I want it to count 1. Attached is a basic example of my spreadsheet. The spreadsheet is very large and adding extra rows is extremely time consuming and difficult due to the other sheets linked to this sheet. If actual production hasn't happened yet then the cell will read "" not blank also.

Re: COUNTIF function

You may use array formula (Ctrl+Shift+Enter to enter) as

`=SUM(--IFERROR(B4:T4/B3:T3>0.95,0))`

It's in B6 in attached

Re: COUNTIF function

Unfortunately this didn't work either. Row 4 contains an if formula that reads another sheet. The if formula returns " " if the cell in the other sheet is blank (if(isblank(Sheet1!A4),"",Sheet1!A4) for example. That is what is making this so difficult. @Sergei Baklan

Re: COUNTIF function

@Adam_Speerstra , if in row 3 is number and in 4 is empty string, in 5 shall be #VALUE! which calculated by formula correctly. Perhaps you could give a sample of what exactly not works? You may type into the cell ="" to imitate returned by IF empty string

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies