# Posts by matyldk

• ## Show maximum value with condition

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

• ## Show maximum value with condition

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

• ## Show maximum value with condition

Hi,

sorry, i didnt point, i had in mind this formula:

=MAX((Sheet2!X:X="mbbravo")*Sheet2!O:O)

• ## Show maximum value with condition

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

• ## Show maximum value with condition

Hello,

im working with the file that should show me the biggest value from column O for user form column X

Book11.xlsx

Many thanks for any help

• ## Problem with COUNTIFS formula, dosnt show proper results

Everything fine now, thanks Rory

• ## Problem with COUNTIFS formula, dosnt show proper results

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

• ## Problem with COUNTIFS formula, dosnt show proper results

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

• ## Problem with COUNTIFS formula, dosnt show proper results

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¨)