Hi,
I have a table calculating times based on several criteria. I have a problem with calculation if one of the cells in the criteria range (B2:B1000) is "" then I get #VALUE! Error. The following is sample table (real table has more than 1000 rows) and in this case B7 is empty cell value:
<tbody>
</tbody>.
.
.
etc.
I tried a couple of solution but I can't get it working without error. I tried to use
I have a table calculating times based on several criteria. I have a problem with calculation if one of the cells in the criteria range (B2:B1000) is "" then I get #VALUE! Error. The following is sample table (real table has more than 1000 rows) and in this case B7 is empty cell value:
=SUMPRODUCT(--(YEAR(A2:A1000)=B1),(B2:B1000))<strike></strike> | 2018 | ||
=IF(D2="","",D2) | 3:15 | 5.6.2017 | |
=IF(D3="","",D3) <strike></strike> | 1:12 | 15.9.2017 | |
=IF(D4="","",D4) <strike></strike> | 2:14 | 6.1.2018 | |
=IF(D5="","",D5) <strike></strike> | 0:55 | 15.2.2018 | |
=IF(D6="","",D6) <strike></strike> | 4:06 | 20.4.2018 | |
=IF(D7="","",D7) | |||
=IF(D8="","",D8) <strike></strike> | 2:16 | 28.7.2018 | |
=IF(D9="","",D9) <strike></strike> | 1:20 | 30.10.2018 | |
=IF(D10="","",D10) <strike></strike> | 3:15 | 3.2.2019 |
<tbody>
</tbody>
.
.
etc.
I tried a couple of solution but I can't get it working without error. I tried to use
<>"" or LEN function but still receiving the error. I would appreciate any help or suggestion.