TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
Hi all,
I want to count the number of rows for which 2 simple logical tests are met.
My data is in range A4:F114.
What I want to do is count how many times:
(I also need to know how many times just column B shows Prepare)
I then tried to expand this using an IF/AND combination:
But this is returning a zero for me even though the condition is met 27 times.
So what obvious step have I missed?
Thanks!
I want to count the number of rows for which 2 simple logical tests are met.
My data is in range A4:F114.
What I want to do is count how many times:
- The first 7 characters in column B are "Prepare"
- The value of column F is "On Time"
Excel Formula:
=COUNT(IF(LEFT(B4:B114,7)="Prepare",1,""))
(I also need to know how many times just column B shows Prepare)
I then tried to expand this using an IF/AND combination:
Excel Formula:
=COUNT(IF(AND(LEFT(B4:B114,7)="Prepare",F4:F114="On Time"),1,""))
But this is returning a zero for me even though the condition is met 27 times.
So what obvious step have I missed?
Thanks!