Report

Max(if..?

Ask a question M_me - Last answered on Nov 8, 2017 at 02:27 PM by M_me
hello,

i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i want a formula to calculate the max of the cells that have some text on the first column, and another one to calculate the max of the cells that don't have text on the first column. how can i do this?
example:
first column second column
m 5
4
j 3
2

the max of the named cells is 5 and the max of the empty cells is 4.

thank you,
:)


Helpful
+0
plus moins
Any answer please??
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!