SUMIF using a cell with a formula in it
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
Check out the Formula Handbook template!