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)
Sumif is defined as per below....
SUMIF(test-values,condition,sum-values)
looks like your have have your condition third not second.
switch them and you should be good.
jason
Sumif is defined as per below....
SUMIF(test-values,condition,sum-values)
looks like your have have your condition third not second.
switch them and you should be good.
jason
I have spent hours puzzling over this. Thank you so much, jaxjason.
Download and keep this handy for anytime you have a problem with a function.
http://manuals.info.apple.com/en_US/Formulas_and_Functions_User_Guide.pdf
jason
Hi Heyolshan,
If you are using Numbers 3.2, you can bring up the functions panel by typing = into a cell.
Browse through the functions that are listed or type the first few letters of the function name
In Numbers 2.3 you can open the function browser by Menu > View > Show Function Browser
or by clicking on this icon on the toolbar.
Regards,
Ian.
A searchable reference on functions (in many languages) is also available here:
SG
Hi Heyolshan,
In the Query table, type the name of a Cap in A2
B2 contains this formula
=SUMIF(Database::B,A2,Database::C)
Regards,
Ian.
Edit. Better is a Pop-Up Menu in A2 of the Query table
That prevents typing errors 😉.
Ian.
I know this thread is a bit old, but just in case anyone sees this: does/can SUMIF work if you are using a pop-up menu to change what is added together?
Suggest starting a new thread with a few more specifics on what you are trying to do.
SG
Numbers drop down filter question
