I need to do a sumif, but stripping the (10997) from the reference cell and also the reference range. Can this be done. in other words, I need to sumif "ABC Corp" is found in a range of cells.
I was trying to incorporate textbefore, but its not working for the reference range part. If any of that makes sense.
Thanks
=IF(SUMIF('GP AP Aging - Detail'!A:A,A19,'GP AP Aging - Detail'!F:F)>0,SUM(C19:I19)-W19,0)
I was trying to incorporate textbefore, but its not working for the reference range part. If any of that makes sense.
Thanks
ABC Corp (10997) |