IF statement using 1,0 within formula

[cs566]

I need some help figuring out someone else's formula/worksheet that I have taken over.

On attached worksheet example:

• Filter on column E (Job Status) and choose 'PSI Confirmed', 'In Progress', and 'Cust Confirmed'.
• Filter on column D (Job End Date). Choose 'October 21, 2020'.
  
• Column I (10/21/2020) SHOULD reflect a count of 'Total Number of Techs' for any of these jobs that are going to occur between the 'Job Start Date' and 'Job End Date'.
  
• The formula in columns I10-I177 through CB10-CB177 should reflect a count of 'Total Number of Techs'.
  
  Example in cell I32:
  =IFERROR(IF(OR($D32="PSI Confirmed",$D32="In Progress",$D32="Cust Confirmed"),IF($A32<>"",IF(I$9<=($C32),IF(I$9>=($B32),1,0),0)*$E32,""),0),0)
  
• The red highlighted part of above formula should be stating that if the column Date Header (10/21/2020) is greater than OR EQUAL to 'Job Start Date', enter a 1 (true), if not, enter a 0 (false). Then, the value would be multifplied by the 'Total Number of Techs'.
• All the cells are multiplying by 0 for selected cells. They should be multiplying by 1.
  

Any help/insight would be greatly appreciated!!

[Limor_OP]

Hi
Why did you take the function =NOW() and not today()

I think that Now includes hour....so that your condition in column I doesnt meet

[cs566]

Well, you are awesome. I thought it would be easy, but didn't think of that...
Thank you so much!
Have a great day!

[Limor_OP]

You're welcome!

[Glenn Kennedy]

Hahaha. I spent too long playing with the formula, I didn't notice the NOW() until rather late in the day.

This is a slightly simpler formula:
=IFERROR(IF(OR($D32={"PSI Confirmed","In Progress","Cust Confirmed"}),IF(AND($A32<>"",I$9>=$B32,I$9<=$C32),$E32,0),0),0)

[cs566]

Thank you for your help.
I did same thing you did... didn't notice the NOW().

I will try out your suggestion on simplier formula.
Thanks again!