I am trying to count how many word chassis from column Failure to Failure 7 was found on 2023. But I have an error #Value. Not sure what I am doing incorrect.
=COUNTIFS(Data[[FAILURE ]:[FAILURE7]],"Chassis",Data[Year],"2023")
=COUNTIFS(Data[Year],B18,Data[[FAILURE]],"Chassis",Data[FAILURE2],"Chassis",Data[FAILURE3],"Chassis",Data[FAILURE4],"Chassis",Data[FAILURE5],"Chassis",Data[FAILURE6],"Chassis",Data[FAILURE7],"Chassis"). Error was 0 and it should be 8.
=SUMPRODUCT(--(Data[[FAILURE ]:[FAILURE7]]="Chassis"),--(Data[Year]=2023)). Error #Value!
Thank you
=COUNTIFS(Data[[FAILURE ]:[FAILURE7]],"Chassis",Data[Year],"2023")
=COUNTIFS(Data[Year],B18,Data[[FAILURE]],"Chassis",Data[FAILURE2],"Chassis",Data[FAILURE3],"Chassis",Data[FAILURE4],"Chassis",Data[FAILURE5],"Chassis",Data[FAILURE6],"Chassis",Data[FAILURE7],"Chassis"). Error was 0 and it should be 8.
=SUMPRODUCT(--(Data[[FAILURE ]:[FAILURE7]]="Chassis"),--(Data[Year]=2023)). Error #Value!
Thank you