Trying to get a formula and calculation to work, need help.

Thanks for your help. Could you also help me how to do Part 2? I was thinking a pivot table but I am not sure.

Part 2

Please refer to the worksheet in the "ExerciseExcel" file called “Data”. Please calculate the median “Avg Guest Check – Overall” for each segment (A,B,C, and Q) for only those average guest checks that are greater than zero. Please save the file with your calculations and/or provide a description of how you accomplished this.

*This is in the same file attached

Originally Posted by pigment01

Please refer to the worksheet in the "ExerciseExcel" file called “Data”. Please calculate the median “Avg Guest Check – Overall” for each segment (A,B,C, and Q) for only those average guest checks that are greater than zero. Please save the file with your calculations and/or provide a description of how you accomplished this.

Try

=MEDIAN(IF(($E$2:$E$76="A")*($D$2:$D$76>0),$D$2:$D$76)) Ctrl Shift Enter

"A" can be changed to a cell reference such as G2 (with G2 having "A" in it without quotes).