Nov 13 2019 12:51 PM
My formula =IF(Countifs(sheet2!C;C, Sheet1!A2)>0, SUM(sheet2!D3-T3), “NO DATA”) only works when sheet1 and sheet 2 data lines up in a row. If the array in sheet 2 is not lined up with sht1, it doesn’t work. I need it to match sheet2 row with sheet1 and then sums D-T data from sht 2
Nov 13 2019 01:17 PM
Now you subtract value of T3 from Sheet2!D3, actually your formula is
=IF(Countifs(sheet2!C;C, Sheet1!A2), sheet2!D3-T3, “NO DATA”)
Or you'd like to work with entire column D in Sheet2?
Nov 13 2019 01:43 PM
Nov 13 2019 01:58 PM
Pingger, if I understood your logic correctly, in Sheet1 here
it could be formula
=IFNA(SUM(INDEX(Sheet2!D:T,MATCH(Sheet1!A1,Sheet2!C:C,0),0)),"no such")
which sums D to T for found row in Sheet2
Please check in attached file.
Nov 13 2019 02:13 PM