How Do I Enter This Formula To Get A %?

%3CLINGO-SUB%20id%3D%22lingo-sub-1805691%22%20slang%3D%22en-US%22%3EHow%20Do%20I%20Enter%20This%20Formula%20To%20Get%20A%20%25%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805691%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%2C%20I%20tried%20replying%20in%20a%20previous%20post%20I%20made%20with%20something%20similar%20but%20wasn't%20able%20to%20post%20it.%20I'm%20assuming%20I%20have%20to%20create%20a%20new%20topic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20back%20with%20a%20similar%20issue%20for%20a%20formula%20that%20I%20hope%20someone%20can%20help%20me%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20to%20track%20a%20%25%20on%20a%20dialy%20basis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20need%20to%20have%20the%20formula%20add%20up%20each%20cell%20for%20each%20day%20(total%20credit%20card%20sales)...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...then%20add%20up%20each%20cell%20for%20each%20day%20(total%20sales)...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E..then%20divide%20the%20total%20credit%20card%20sales%20by%20total%20sales%20to%20give%20me%20the%20total%20credit%20card%20%25%20for%20that%20day.%20Doing%20this%20for%20one%20day%20is%20easy%20and%20works%20fine.%20But%20when%20I%20try%20to%20select%20the%20remaining%20days%20of%20the%20week%20(Tue-Sun)%20I%20run%20into%20issues%20and%20don't%20know%20how%20to%20create%20the%20right%20formula%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20how%20would%20I%20type%20this%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20using%20the%20following%20formula%20but%20this%20gave%20me%20the%20wrong%20result%20as%20it's%20adding%20up%20everything%20I%20think...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(L30%2BS30%2BZ30%2BAG30%2BAN30%2BAU30%2BBB30%2F(I30%2BP30%2BW30%2BAD30%2BAK30%2BAR30%2BAY30)%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20It%20is%20extremely%20difficult%20to%20post%20in%20this%20forum.%20I%20always%20get%20weird%20errors%20in%20purple%20saying%20%22Post%20flooding%20detected...%22%20and%20I%20can't%20post%20without%20spending%2010%20minutes%20trying%20to%20do%20this.%20It's%20the%20most%20bizarre%20format%20for%20a%20forum%20I've%20ever%20used.%20Just%20strange...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1805691%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-1811004%22%20slang%3D%22en-US%22%3ERe%3A%20How%20Do%20I%20Enter%20This%20Formula%20To%20Get%20A%20%25%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1811004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825432%22%20target%3D%22_blank%22%3E%40Nickers24_2020%3C%2FA%3E%26nbsp%3BDifficult%20to%20visualise%20your%20actual%20schedule%2C%20but%20the%20formula%20you%20provided%20is%20adding%20up%20all%20values%20L30%20through%20AU30%20and%20then%20adds%20B30%20divided%20by%20the%20total%20of%20the%20cell%20within%20the%20brackets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20add%20up%20the%20first%207%20cells%20and%20divide%20the%20total%20by%20that%20of%20the%20other%207%2C%20you%20need%20to%20add%20a%20set%20of%20brackets.%20Try%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFERROR((L30%2BS30%2BZ30%2BAG30%2BAN30%2BAU30%2BBB30)%2F(I30%2BP30%2BW30%2BAD30%2BAK30%2BAR30%2BAY30)%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Sorry, I tried replying in a previous post I made with something similar but wasn't able to post it. I'm assuming I have to create a new topic.

 

I'm back with a similar issue for a formula that I hope someone can help me with.

 

I'm trying to to track a % on a dialy basis.

 

I think I need to have the formula add up each cell for each day (total credit card sales)...

 

...then add up each cell for each day (total sales)...

 

..then divide the total credit card sales by total sales to give me the total credit card % for that day. Doing this for one day is easy and works fine. But when I try to select the remaining days of the week (Tue-Sun) I run into issues and don't know how to create the right formula to do this.

 

So how would I type this formula?

 

I tried using the following formula but this gave me the wrong result as it's adding up everything I think...

 

=IFERROR(L30+S30+Z30+AG30+AN30+AU30+BB30/(I30+P30+W30+AD30+AK30+AR30+AY30),0)

 

P.S. It is extremely difficult to post in this forum. I always get weird errors in purple saying "Post flooding detected..." and I can't post without spending 10 minutes trying to do this. It's the most bizarre format for a forum I've ever used. Just strange...

3 Replies
Highlighted

@Nickers24_2020 Difficult to visualise your actual schedule, but the formula you provided is adding up all values L30 through AU30 and then adds B30 divided by the total of the cells within the brackets.

 

If you want to add up the first 7 cells and divide the total by that of the other 7, you need to add a set of brackets. Try this:

 

=IFERROR((L30+S30+Z30+AG30+AN30+AU30+BB30)/(I30+P30+W30+AD30+AK30+AR30+AY30),0)

 

 

Highlighted

Yes, that worked! Thank you very much sir!

Highlighted