Numbers drop down filter question
This has been answered in this forum before, but I'm a novice to spreadsheets and I'm having trouble with a formula. Here's what I'm trying to do:
Column B is a drop down menu of 3 choices--Large Cap, Mid Cap, Small Cap. Cell C9 should be a sum of Column C of anything designated Large Cap in Column B. My formula is =SUMIF(B2:B7, C2:C7, "=Large Cap"). What am I doing wrong, and is there a better way?
MacBook Air, OS X Mavericks (10.9.4)