Forum Discussion
Assigning data a class and then performing calculations on that specific class
Hi Dustin
This formula might work for you:
=AVERAGEIF(A1:A8,"1",B1:B8) <-- will only avg $ for Class 1
=AVERAGEIF(A2:A8,"=1",C2:C8) <-- will only avg Weight for Class 1
=AVERAGEIF(A1:A8,"2",B1:B8) <-- will only avg $ for Class 2
=AVERAGEIF(A2:A8,"2",C2:C8) <-- will only avg Weight for Class 2
I have attached the file you uploaded with the formula.
Hopefully I have understood you right. Let us know how you go?
Cheers
Damien
Hi Dustin
This formula might work for you:
=AVERAGEIF(A1:A8,"1",B1:B8) <-- will only avg $ for Class 1
=AVERAGEIF(A2:A8,"=1",C2:C8) <-- will only avg Weight for Class 1
=AVERAGEIF(A1:A8,"2",B1:B8) <-- will only avg $ for Class 2
=AVERAGEIF(A2:A8,"2",C2:C8) <-- will only avg Weight for Class 2
I have attached the file you uploaded with the formula.
Hopefully I have understood you right. Let us know how you go?
Cheers
Damien
Hi Damien,
That works perfect for finding the average. Thank you very much and for the quick response! I also was needing to find the Median. Guess what? MEDIANIF is not a formula!! Any insight as to how to go about finding that?
Thanks again!
- Hi Dustin
Happy to help.
For the Median, are you asking to calculate the Median for the $ and weight for both Class 1 and Class 2?
Cheers
Damien- Yes sir!
