Quartile with if statement

[Muhammad Hussaan]

If i have a column A with data 1, 2, 3....12 (multiple reading of 1, 2, 3 ...12; represents months) and column B having sales volume data in number from 1 to x. I want to find QUARTILE of Column B with condition of Column A. How i can do this? Please help me..

 

[Scott Huish]

What do you mean by condition of column A. What is your condition?

 

[Muhammad Hussaan]

Condition means conditional for example if i want to find Quartile of data in column B with conditional 1 in column A.

 

[Scott Huish]

Something like this perhaps:

=QUARTILE(IF(A1:A12=1,B1:B12),1)

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

 

[Muhammad Hussaan]

Thanks. It works

 

[Muhammad Hussaan]

How to ignore zero and empty cells in B1:B12

 

[Scott Huish]

=QUARTILE(IF(A1:A12=1,IF(B1:B12<>0,B1:B12)),1)

Confirm with CTRL-SHIFT-ENTER

 

[Muhammad Hussaan]

Thanks