What is the formula?

[Accountstep]

Hello, Can someone tell me the formula to enter for the following equation? Thanks!

Here is a snapshot, hope this helps:

I have 500.00 dollars in one cell and want to divide it by two whole numbers in other cells.... for e.g.


$500.00 (Cell A) divided by
number 54 (Cell B) plus
number 87 (Cell C) plus
number 3 (Cell D)
= Total $dollars or cents

This is what I've tried =SUM(CellA)/CellB,CellC,CellD... but it doesn't work.

Any suggestions?

<TABLE style="WIDTH: 394pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=524 x:str><COLGROUP><COL style="WIDTH: 142pt; mso-width-source: userset; mso-width-alt: 6912" width=189><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 206pt; mso-width-source: userset; mso-width-alt: 10020" width=274><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; WIDTH: 142pt; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17 width=189>Daily HD</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: #ffcc99; BORDER-TOP-COLOR: #c0c0c0; WIDTH: 46pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl25 width=61 x:num="190723">190,723 </TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; WIDTH: 206pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl22 width=274>< B) &</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17>Sunday HD</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl23 x:num="46777">46,777 </TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl23></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl23></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17>Daily HD</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: #ffcc99; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl25 x:num="721681">721,681 </TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl22>< C)</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17>Sunday HD</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl23 x:num="178460">178,460 </TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl24></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17>Delivery Fee/Copy HD Daily</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: #ccffcc; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl27 align=right x:num="-0.55">(0.5500)</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl22><FORMULA font VALUE)< ($CENTS HERE GOES></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17>Delivery Fee/Copy HD Sunday</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl24 x:num="-2.94">(2.9400)</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: #ff99cc; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl26 align=right x:num="-423321.26">(423,321)</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl22>< A) DIVIDED BY:</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" height=17></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0" class=xl22 height=17>$423,321.00 / B2,B6 = CENTS</TD><TD style="BORDER-BOTTOM-COLOR: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #c0c0c0; BORDER-RIGHT-COLOR: #c0c0c0; BORDER-LEFT-COLOR: #c0c0c0"></TD></TR></TBODY></TABLE>

 

[Nalani]

I don't think your "snapshot" is doing any justice to what you may want.

Maybe this, for the first part of your post. Although you say "divide by two numbers", but your example formula has three:

I have 500.00 dollars in one cell and want to divide it by two whole numbers in other cells.... for e.g.


$500.00 (Cell A) divided by
number 54 (Cell B) plus
number 87 (Cell C) plus
number 3 (Cell D)
= Total $dollars or cents

This is what I've tried =SUM(CellA)/CellB,CellC,CellD... but it doesn't work.

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-LEFT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">$500.00</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">54</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">87</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">3</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">$3.47</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>E1</TD><TD>=A1/SUM(B1:D1)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


The rest of your "screenshot" has me lost.

If you would like to post the Actual Data, Download one of the Addins listed at the bottom of my post.

 

[Accountstep]

Nalani, I appreciate your help.

What if the Cells of B, C, and D are not consequtive, for e.g.

Would it be: =A1/SUM(B2,C53,E8) ?

Thanks again!

 

[wigi]

Would it be: =A1/SUM(B2,C53,E8)

It does not hurt to try this out - it gives more satisfaction if you find the answer yourself rather than getting the answer from someone here.

Yes, that should work too.