help with sumif function

%3CLINGO-SUB%20id%3D%22lingo-sub-2262947%22%20slang%3D%22en-US%22%3Ehelp%20with%20sumif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2262947%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(%22Donor-List%5BYears%20of%20Support%5D%22%2C%22%26gt%3B15%22%2C(%22Donor-List%5BTotal%20Annual%20Donations%5D)%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2262947%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2263034%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20sumif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1021231%22%20target%3D%22_blank%22%3E%40Lisa2045%3C%2FA%3E%26nbsp%3BYou%20didn't%20specify%20the%20entire%20formula%20and%20it%20seems%20you%20are%20working%20with%20structured%20table%20references.%20And%20perhaps%20some%20quotation%20marks%20and%20brackets%20were%20included%20accidentally.%20Having%20my%20doubts%20about%20the%20table%20name%20as%20well%20as%20in%20my%20Excel%20it's%20not%20allowed%20to%20use%20any%20other%20special%20character%20than%20an%20under%20score%20%22_%22%20in%20the%20name.%20So%2C%20check%20the%20table%20name%20and%20try%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUMIF(Donor_List%5BYears%20of%20Support%5D%2C%22%26gt%3B15%22%2CDonor_List%5BTotal%20Annual%20Donations%5D)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2263099%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20sumif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263099%22%20slang%3D%22en-US%22%3EThat%20did%20not%20work%20so%20there%20must%20be%20an%20error%20somewhere%20and%20I%20am%20reading%20it%20from%20chapter%2011%20Excel%20book.%3C%2FLINGO-BODY%3E
Occasional Visitor

 

("Donor-List[Years of Support]",">15",("Donor-List[Total Annual Donations])"

9 Replies

@Lisa2045 You didn't specify the entire formula and it seems you are working with structured table references. And perhaps some quotation marks and brackets were included accidentally. Having my doubts about the table name as well as in my Excel it's not allowed to use any other special character than an under score "_" in the name. So, check the table name and try this:

=SUMIF(Donor_List[Years of Support],">15",Donor_List[Total Annual Donations])

 

That did not work so there must be an error somewhere and I am reading it from chapter 11 Excel book.

@Lisa20451545 You need to be a bit more specific. what "Excel book"? Can you upload the file (without private or confidential information, though)?

The class occurs tomorrow morning. 365 large Excel book. Instructor will go over the RYS exercise.

@Lisa20451545 Sorry. Don't know anything about the book/course you refer to.

You wrote "that did not work so there must be an error somewhere ...".  That's it? Without an example of the Excel file where the formula is supposed to work, there's no way to tell what's wrong or why.

waiting for class to start so instructor should be able to explain and I can share screen with her if she cannot get formula to work

@Lisa20451545 Entered my formula in F23. Seems to work just fine!

thank you