based on my data entry, i'm creating a report to check what was my daily production and if there is no production then mark the day as red. here is the formula:
=IF(SUMIF(B9:B73,AZ9,E9:E73)<>0,SUMIF(B9:B73,AZ9,E9:E73),"")

where:
B9:B73 is product manufacturing date
formula is checking AZ9 (date here) then checking E9:E73 for number of item manufactured - based on this i'm getting total items for that date in cell BB9

here i'm also using conditional format to mark cell red if there is no production on that date. Conditional formula is: =LEN(BB9)=0 then mark red

i have 2 issues here:
1 - i need to get 0 in BB9 if there is no production
2 - i have set a daily target to 200 and checking the difference in next cell BC9 that what was difference on this date. Using this formula on BC9: =IF(BB9="","",BB9-BH5) but i'm getting the cell blank if it is receiving 0 from BB9 but i need to see -200 here

I think if somehow we can get 0 in BB9 (as mentioned in issue 1) then BC9 (issue 2) will resolved automatically.

need help please. thanks.