X
Xbrokylnboy
I wanted to know if there ia a forumla lthat can
Take data in Cloumn Mrow 5 in Spreadsheet 1 ,and comapre that to spreadsheet
2 column G and return the corresponding value in Ion spreadsheet 2, then
Using the data in Column C it would need to look at colum Hon spreadsheet 3
and summing up all items in column b on spreadsheet 3.
I think that this is an array. Best that I could do is to get only one item
to sum.
SUM(IF((IF($M$5>0,RIGHT(Exposure!$H$2:$H$15000,3)=RIGHT(INDEX(SBU_MU_Codes!$G$1:$I$15000,IF(SBU_MU_Codes!$G$1:$I$15000=$M$5,ROW(SBU_MU_Codes!$G$1:$I$15000)),ROW(7:7)),3),"
"))*(Exposure!$Q$2:$Q$15000<0)*(Exposure!$A$2:$A$15000>0)*((Exposure!$A$2:$A$15000
- Exposure!$C$2:$C$15000)<=30)*((Exposure!$A$2:$A$15000 -
Exposure!$C$2:$C$15000)>=0),Exposure!$Q$2:$Q$15000))
Take data in Cloumn Mrow 5 in Spreadsheet 1 ,and comapre that to spreadsheet
2 column G and return the corresponding value in Ion spreadsheet 2, then
Using the data in Column C it would need to look at colum Hon spreadsheet 3
and summing up all items in column b on spreadsheet 3.
I think that this is an array. Best that I could do is to get only one item
to sum.
SUM(IF((IF($M$5>0,RIGHT(Exposure!$H$2:$H$15000,3)=RIGHT(INDEX(SBU_MU_Codes!$G$1:$I$15000,IF(SBU_MU_Codes!$G$1:$I$15000=$M$5,ROW(SBU_MU_Codes!$G$1:$I$15000)),ROW(7:7)),3),"
"))*(Exposure!$Q$2:$Q$15000<0)*(Exposure!$A$2:$A$15000>0)*((Exposure!$A$2:$A$15000
- Exposure!$C$2:$C$15000)<=30)*((Exposure!$A$2:$A$15000 -
Exposure!$C$2:$C$15000)>=0),Exposure!$Q$2:$Q$15000))