SUMIF using a cell with a formula in it

Kirstine

Wow, I forgot all about this! So... it now works using the formula below. I got around it by entering the Customer Ref (PO) manually rather than using a VLOOKUP. 

=SUMIF([Customer Reference for Invoice]:[Customer Reference for Invoice], [Customer Reference for Invoice]1, [Value to be invoiced]:[Value to be invoiced])

It would be nice to get it working as originally intended though. 

Paul Newcome

Good that you were able to find a working solution.

 

If you would like to share the sheet(s) with only test data I may be able to get in there, play around and possibly help you find a solution that will work as originally intended.

Kirstine

That would be good, thanks! 

Paul Newcome

Ok. You can just post a published link here then, and I'll hop in and take it for a spin.

Kirstine

I'll set it all up with test data and then will post it here once it's done. I'm assuming you'll need all the associated sheets too...? 

Paul Newcome

Whatever sheets you are referencing.

Kirstine

Sorry... that took a lot more brain power than I was expecting on a Friday afternoon...! I hope I'm doing this right. The top one is the one we're looking at, the other two are there for the links only. (Please don't laugh at any long-winded formulas I've done! I'm self taught!)

https://app.smartsheet.com/sheets/4mppRM4WPpjxw95Ph3XpFgj99vx696RHXW32HR51

https://app.smartsheet.com/sheets/HqR2M5x9PW32CmfgpJWgJvw8h7H2Hj5552MVXj61

https://app.smartsheet.com/sheets/58P76h9MpX3wqXxp3HJ6CqRRWvQv6vqVPmR3g2w1

Paul Newcome

I'll take a look and use @mentions in the comments of the sheets if I have any questions. And no worries about being self taught. So am I. 

 

EDIT: I requested access to the sheets as when I clicked on the links you provided I was met with a 404 error.