'exact error message is this - "A value used in this formula is the wrong data type."

=SUMIFS(O2:O7,I2:I7,"<>Completed",B:B,"=B2")

Column O has numbers Column I has Text Values (e.g. Incomplete, Completed) Column B has dates in the format 16-Feb-22

I am getting value error, can anyone please help?

exact error message is this - "A value used in this formula is the wrong data type."



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source