Max(if..?

M_me - Nov 6, 2017 at 02:36 PM - Latest reply:  M_me
- Nov 8, 2017 at 02:27 PM
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,
:)


See more 

Your reply

1 reply

0
Thank you
Any answer please??
Respond to M_me