Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi can anyone please help me how to fix this formula problem i am sure that my formula is correct, however i cant continue
Hi can anyone please help me how to fix this " formula problem" i am sure that my formula is correct, however i cant continue since this popsup
File Home Insert Page Layout Formulas Data Review View Help fx Define Name Use in Formula Ey Trace Precedents Vox Show Formulas a Trace Dependents Error Checking FRemove Arrows Evaluate Formula Name Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Manager EO Create from Selection wi Function Library Defined Names Formula Auditing X fi =SUMIFS(RawData[Sales revenue], RawData[Year],RawData[Division],$B$6, RawData[Region],'calculation divison'!) A B D E F H K L M N Forma 1 2 3 Microsoft Excel 4 Division 5 There's a problem with this formula. Fill Division -7 Year Office supplies Current Books 6 Line Not trying to type a formula? When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula: 7 Electronics 8 Office supplie you type: = 1+1, cell shows: 2 9 10 To get around this, type an apostrophe () first: 11 you type: '= 1+1, cell shows: = 1+1 12 OK Help 13 14Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started