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. "