COMBINING SUMIFS & VALUE FUNCTIONS TOGETHER

[Seaneboy2020]

Hi there,

Does anyone know if there is a way to combine both the SUMIFS and VALUE functions together, in order to convert my criteria range from text to a number?

If so, could you please show me how I would write such a formula?

Many thanks

Seab

[#2]

@Seaneboy2020 

In SUMIFS() range shall be a range, not some transformation of it. You may use SUMPRODUCT() or adjust criteria.