It works perfectly, thanks so much, you saved probably much of my time!
Posts by matyldk


Seems like in my Excel version there is nor formula like that
I used this: =MAX((Sheet2!X:X="mbbravo")*Sheet2!O:O)
but i got answer 0 which is not correct, not sure what is wrong with that

Hi,
sorry, i didnt point, i had in mind this formula:
=MAX((Sheet2!X:X="mbbravo")*Sheet2!O:O)

Yes, extactly, it should fetch data from Sheet2, but as result as get 0, it should be 1

Hello,
im working with the file that should show me the biggest value from column O for user form column X
Many thanks for any help

Everything fine now, thanks Rory

Hi,
i had to cut the workbook so it changed location of the cells, but ive already changed the formula to it gets proper cells

Sorry, i wanted to mean that it should look in column T

Hi all!
Im trying to get the summary of cells in two columns that in column AN have value of 1 and in Column F nickname that i choose.
I got the wrong results, it shows me always 0 ;/
Maybe somebody knows whats wrong with this formula?
=COUNTIFS(Sheet2!$AN:$AN,1,Sheet2!$T:$T,¨mbbravo¨)