sum => sumif ; max ==> maxif??

[c_ka_kit]

There is a function sumif() that is used for do sum() under condition

Nevertheless, if I want to do max() under condition, how can I do?

There isn't a function maxif().

[Bryan Hessey]

There is a function sumif() that is used for do sum() under condition

Nevertheless, if I want to do max() under condition, how can I do?

There isn't a function maxif().

Hi,

you need to modify

=MAX(IF(C1:C12=1,D1:D12))

CSE (CTRL/Shift/Enter)

to suit your data

---

[c_ka_kit]

Thank . by my problem is not yet solved.

=MAX(IF(C1:C12=1,D1:D12))

gives max(D1:D12) always. when C column is 1.

However, I need to get Max(D1, D2, D12) if C1=1 and C2=1 and C12=1.

sumif and countif can do such filtering sum and count.

Any idea??

[Bryan Hessey]

Thank . by my problem is not yet solved.

=MAX(IF(C1:C12=1,D1:D12))

gives max(D1:D12) always. when C column is 1.

However, I need to get Max(D1, D2, D12) if C1=1 and C2=1 and C12=1.

sumif and countif can do such filtering sum and count.

Any idea??

ok - then

=IF(AND(C1=1,C2=1,C12=1),MAX(D1,D2,D12),"")

---

[arthurbr]

Other possibility:
=IF(c1*c2*c12=1,MAX(D1,D2,D12),"")

[Bryan Hessey]

Other possibility:
=IF(c1*c2*c12=1,MAX(D1,D2,D12),"")

but that works for
2 1 0.5

--

[c_ka_kit]

"C1=1,C2=1,C12=1" is only an example condition.

The general request statement is

"For any row that C column cell is 1, the D column data is to be taken and finally, find the max of these D data. "

[Bryan Hessey]

"C1=1,C2=1,C12=1" is only an example condition.

The general request statement is

"For any row that C column cell is 1, the D column data is to be taken and finally, find the max of these D data. "

please be specific, my first formula did this, which you then requested as C1 C2 and C12 all = 1

You may need to supply a sample with your expected answer.

---
added, note as per the statement, you need to enter the formula with CTRL/SHIFT/Enter (not just Enter)

[c_ka_kit]

OK! The "CSE" works. Thank You.

[Bryan Hessey]

OK! The "CSE" works. Thank You.

always for 'array' formula, good to see it works for you, and thanks for the response.

---