Hi,

I'm trying to get a simple Sumif formula to work. I have used this formula a hundred times before but this time the results are inaccurate. I suspect that it may be because of the math symbols which are used in the criteria text i.e. < and >

My formula is as follows:

=SUMIF('Raw Data Export'!D:D,"< No Project >",'Raw Data Export'!G:G)

A data extract from the sheet named "Raw Data Export" is attached.

Regards,

Leanne

I'm trying to get a simple Sumif formula to work. I have used this formula a hundred times before but this time the results are inaccurate. I suspect that it may be because of the math symbols which are used in the criteria text i.e. < and >

My formula is as follows:

=SUMIF('Raw Data Export'!D:D,"< No Project >",'Raw Data Export'!G:G)

A data extract from the sheet named "Raw Data Export" is attached.

Regards,

Leanne

## Comment