Used a pivot table for this - the variances are completely different. Can someone let me know why? Also - seems like the totals for the Over 35+Below 35 is 175 in the video/solution - but there should only be 174?

Hey Bianca, Do you want to share a screenshot of your work, please? Thanks!

I only added the age grouping... Thank you!

Well, I would recomend you use VARPA formula it good to go to find variance for any approbiate value how to use it easy =VARPA(IF(Dataset!$E$5:$L$178="Female",Dataset!$K$5:$K$178)) =VARPA(IF(Dataset!$E$5:$L$178="Male",Dataset!$K$5:$K$178)) =VARPA(If(enter yourrange="Female", target column)) now you have to hit (ctl + shift + Enter) and you will get the same results hopefully that help you