Count Maximum Days Based on Status

[kumara_faith]

Hi,

I have three columns. Column A has the task type , column B the number of days and column C has the status as Completed or Pending. I need to show the maximum days pending for any task that has been tagged as Pending in column C. I am using the following formula but it does not work. Appreciate any help.

=IF(C3:C12="Pending",MAX(B3:B12),"")

 

[jtakw]

Hi,

If you have the MAXIF function (available with Office365 subscription), you can use that, otherwise, Array formula to be confirmed by CSE, instructions below:

Book1
	B	C	D	E
1	10	Pending		20
2	30	Completed
3	20	Pending
4	25	Completed
Sheet518

Cell Formulas
Range	Formula
E1	{=MAX(IF(C1:C4="Pending",B1:B4))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[kumara_faith]

Hi jtakw,

Thank you, that worked. Appreciate your time.

 

[jtakw]

You're welcome.