SUMIF using a cell with a formula in it

Kirstine ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

OK, so my formula is this: =SUMIF([Customer PO]:[Customer PO], [Customer PO]2, [Value to be invoiced]:[Value to be invoiced]). I'm pretty sure it's correct, but the 'Customer PO" column uses a VLOOKUP formula which I think is what's causing a #NO MATCH error...? 

Is there any way to get around this? 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!