Log In
Register
Home
July 19, 2023
Offline
Hello,
I am using Excel 365, and the following formula is not producing the results I am seeking,
=IF(AND(H:H>=1, OR(A:A="", A:A="WIP")), 1, ""), right now I am not seeing anything in column V.
The purpose of the Formula is to add total jobs that are being worked on (WIP) or that need to be worked on (Blank).
I need a number 1 placed in column V if all conditions are met and a 0 if there is anything else in Column A, as there are multiple letters that are auto populated due to other formulas.
I want to use a formula in a different cell to add up column V to let the inspectors know how many jobs are in the que.
See Answer
Trusted Members
Moderators
November 1, 2018
Offline
AND and OR only return one result, not an array of results. so you would need to enter the correct formula into one cell and copy it down - eg
=IF(AND(H5>=1, OR(A5="", A5="WIP")), 1, "")
July 19, 2023
Offline
Hello,
That works great; However, it is displaying a 1 in column V when both columns are blank. I need a 0 where both are blank, since I am counting the 1's to show how many jobs are in QA.
1 Guest(s)
