Hi,
I have three sheets: the first contain many data and the second and third have to find specific data in the first one.
With help of this excelent excel knowledge source, I made this formula that I use in the second sheet:
=SUM(COUNTIFS(brut!$B:$B;"1T";brut!$G:$G;"K13"; brut!$D:$D;{"1";"2";"3"}
Where brut is the first sheet and "1T", "K13" , "1","2","3"are arguments to look and count.
it works fine and the result of the formula is numbers - if the result is 1, 1, if the result is 2, 2...
I would like some help for the third sheet. I need that the formula give not a result but what are in a cell in the first sheet.
I made this formula:
=IF(COUNTIFS(brut!$B:$B;"1T";brut!$G:$G;"K13"; brut!$D:$D;{"1"});brut!$E:$E; 0)
Where brut is the first sheet and "1T", "K13" and "1" are arguments to look and brut!$E:$E is the result that I want.
What happened:
The result is not related to the argument "K13" that I want, but is brut$E:$E in the line 13. If I change to "k17", is brut$E:$E in line 17.
Thanks in advance,
Regards from Brazil
Bookmarks