I am facing a trouble programming in Excel. I have a formula in a workbook that is located in a page "stats" and 31 sheets in the same workbook representing a file of work. So I wrote a formula allowing me to verify in the 31 pages the presence of a person with this formula
Code:
=SUMPRODUCT( NB. IF( INDIRECT ( LINE ( INDIRECT ( "1:31" ) ) & "!$F$15" ) ; "4075" ) )
4075 is the value of a registration number of an agent
My worry is that the Excel will see in the box f15 if 4075 is present and therefore adds a work 1 and so on about 31 sheets in f15. This works great, but the worry is that this agent may be of f15 to f29 or f32 to f40. I can not state in my formula in Excel verifier presence of 4075 of f15 to f29 or f32 to f40 on 31 sheets.
Code:
=SUMPRODUCT( NB. IF( INDIRECT ( LINE ( INDIRECT ( "1:31" ) ) & "!$f$15" & "!$f$16" & "!$f$17" ) ; "X" ) )
but its not working?
Bookmarks