Formulas =SUMIF

kane.godfrey

Hi, 

I need help to solve this puzzle. I'm using this sumif formula  

=SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value})

to sum up the total value of invoices against a particular order number. 

I've checked that all columns are formatted as text. See snap shot of actual formula attached. 

Cheers 

Kane 

Paul Newcome

What issue exactly are you having?

kane.godfrey

For further clarity the formula is returning a zero result instead of 2000

kane.godfrey

Hi Paul, 

 The formula is returning a zero result instead of 2000. 

Cheers 

Kane