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!!
Bookmarks