# Addition In Base 6

Jun 14, 2009
I've got a column of numbers that represent the number of overs bowled in games of cricket. Whilst these are whole numbers (eg. 34 overs + 34 overs) the addition isn't a problem, but when they are incomplete overs (eg. 34.4 overs + 34.5 overs) then the addition if out of kilter as it sums them in base 10, and not in base 6. (As there are six balls in an over, not ten for anyone who doesn't know!)

View 2 Replies
ADVERTISEMENT
Nov 19, 2008

make a calculation(addition) and use the answer to multiply against another addition calculation....

The sum of (Monday!A1:A4) multiplied by the sum of (Monday!B1:B4) plus (Tuesday!A1:A4) multiplied by the sum of (Tuesday!B1:B4) and so on.

View 2 Replies
View Related
Feb 8, 2007

I wanted to have the weeks of the month down one column = 52 week.

down the next column I have different amounts of money in that week.

some months have 4 weeks and other have 5. I wanted a program to say:

If you see a month "x" look at the next column and take that amount. Then on the next row you have month "x" again (week 2) go to the next column and take that amount and add it to week one. And so on until all 4/5 week are added to give on result.

Then the same for the next month...

month amount/week amount/month

05-Mar 0

12-Mar 70

19-Mar 210

26-Mar 350 1050

02-Apr 420

09-Apr 455......

View 9 Replies
View Related
Mar 16, 2009

I am hoping someone with excel experience can be of help to me with an unusual request for excel.

Assume cell A1 = 2, B1 = 3 and i wish the sum of this (5) to appear in cell C1. Very straight forward so far, however i wish the result to appear in C1 when i left click on a cell other than C1, say for example D7.

I can't use any macros for this.

View 11 Replies
View Related
Jun 11, 2009

I need to C8 - C19 only to add up jobs won by andrew (in current orders). It needs to be month specific. what i mean by that is I need the formula to do what its doing now (adding up the jobs by and putting the totals into the according cell depending on what month they were won.

View 2 Replies
View Related
Dec 28, 2009

I have multiple ranges in a spread sheet. I am trying to write a formula that will go out to each range in succession and look for a part number, upon finding return a quantity and them move on to the next range duplicating the above process. The formula should tally the grand total of all numbers found. I have it working except that not all of my items are in all ranges. If the item that I am searching for is in all ranges my formula works but if there is one or more of the ranges that doesn't have that particular value it returns an #n/a instead of totalling those that do have it. If I use a true instead of false in my [range_lookup] I get an incorrect answer. My formula for a given cell is listed below. This is with the true argument which does not work....

View 9 Replies
View Related
Aug 13, 2008

I am a new excel user. I a trying to write a certain formula but am having trouble. I want to write the formula to add a column of numbers, say H-10 through H-15. Each cell will have a number in it, but I want only to add the cells if the cell precedding it in the G-10 through G-15 Collumn is blank. For example if cells G-12 and G-14 have an "X" in them, then I do not want Cells H-12 and H-14 to be added. I only want the formula to add cells H-10,H-11,H-13, and H-15. I used just 6 cells for example, the column of cells to be added will be a lot longer.

View 3 Replies
View Related
Jan 27, 2009

I obviously know less about functions than I thought I did. I've got the attached spreadsheet set up except getting totals at the bottom. The production total L44, would be column A multiplied by the quantity entered in columns L and summed. Same for Total SF, square footage in column B times quantity in L and summed at the bottom. This would continue daily, needing sums under each column.

View 4 Replies
View Related
Sep 25, 2009

Have an excel table with following data:

- ID

- number of bottles

- number of bottle crates (there are 20 bottles in one one bottle crate)

201688194000bottles

20168819200crates

2016883812000bottles

20168838600crates

201688396400bottles

20168839320crates

201688809000bottles

20168880600bottles

20168880480crates...................

I need to write a macro which will do this operation for each ID:

(bottles/20)-crates = x

and if "x" is not 0 then write down the value of "x".

There are two points I would like to point out:

- One ID may contain 3 or more rows (see 20168880)

- The macro will work with hundreds IDs so the algorithm should be fast (but it is not necessary)

View 3 Replies
View Related
Jan 11, 2013

I wish to sum specific rows in a spreadsheet as a Grand Total. I eventually end up with a string variable called "GrandTot" that holds "=C3+C13+C25+C31+C39+C50+C53"

This formula is correct, but when I insert it into the spreadsheet it totals zero. Only when I manually write the formula does it recognize the cells it supposed to add. I am very confused as to why this is happening.

On a possibly related note, when I highlight a column in the spreadsheet, the count is including blank cells.

View 3 Replies
View Related
Jan 16, 2013

I have a macro that basically captures all of the errors in my spreadsheet and summarizes them under 3 columns (Value in Cell, Sheet, Cell) so that I can quickly identify the error message as well as it's location. I wanted to take it a set further and add a hyperlink for each error so that the user can quickly go to the error location to investigate. I really don't care where the hyperlink is located as far as which 3 columns.

Range("G2").Select

Selection.End(xlToRight).Select

Selection.End(xlDown).Select

Selection.End(xlToLeft).Select

Selection.End(xlUp).Select

curRow = ActiveCell.Row + 3

[Code] ........

View 6 Replies
View Related
May 1, 2013

Lets say I have a #2 in cell A1 and #4 in cell B1 and would like an output in C1 as "plus 2".

Right now I have =if(a1>b1,b1-a1,???) what can I put in the [value_if_false] to return "plus 2" or do I have to use another formula?

View 1 Replies
View Related
Jun 30, 2014

I have this in cell F5

CM26 (85) CM16 (39) CM25 (12)

I need to add the numbers in brackets up and put the total in G5.

View 3 Replies
View Related
Mar 27, 2009

I AM HAVING DATA OF 210 BRANCHES OF DIFFERENT ITEMS. EACH BRANCH HAS AROUND 100 TO 150 ITEMS. I WANT TO ADD THE VALUES OF EACH BRANCH AND I HAVE TO GET THE GRAND TOTAL VALUE IN A SINGLE SHEET. SUPPOSE IF ADD E10+E210+E350+E470 LIKE THIS AFTER SOME pLUSES I WILL GET THE FORMULA RANGE IS OVER. IS THERE ANY METHOD OF ADDING 210 BRANCHES ITEMS

View 9 Replies
View Related
Jun 16, 2014

I am looking for a method to count the number of amounts in an addition.

For example, let's assume that A1 contains 354.92+29+84.7+45 That addition contains a total of four different amounts that have been added So, I am looking for a formula that will display the total number of amounts (4) in a different cell.

Another example:

A1 -> 75+9+237

A2 should show -> 3

View 7 Replies
View Related
Dec 29, 2008

I have Names in column A, Data in Column B. Example

A1 John B1 1000 C1 5:32:05

A2 Jim B2 500 C2 5:56:55

A3 John B3 600 C3 6:45:65

A4 Bill B4 300 C3 7:21:05

In another column I have the names of all the possible people that I will need data from and next to them I will need a formula to tabulate all their totals from column B and then another formula that will skip B and total column C's total.. I have a formula that I used from awhile ago when I needed to offset the data but I can't figure out how to just take the data to the right of it and then another formula to skip column B. Here is my old formula =SUMPRODUCT(($A$1:$A$291=G14)+0,OFFSET($B$1:$B$291,1,0)+0)

View 2 Replies
View Related
Mar 27, 2009

I imagine this is a simple conditional SUMIF function. I'd like a cell to add values in e.g. column "d" when that row meets certain criterion in column "a".

In other words, I have a column that has times recorded in minutes, and another that says a person's name which correlates with the times. I'd like a cell on another sheet to give a total sum of minutes for each person.

Ideally, part of the function would translate the minute count into hours/minutes, but I think I can figure out how to do that by changing the format in the cell...

View 6 Replies
View Related
Oct 20, 2009

I would like to know the calculator formula for addition via columns.

Eg 1. If i were to place 135 into Column A ;

12.95 into Column C ;

i would need to yield a result of 147.95

Eg 2. Place 189 into Column A ;

12.95 into Column C

i would need to yield result of 201.95 and so on. in the attachment is the sample file.

View 2 Replies
View Related
Jan 8, 2009

Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options.

If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?

View 2 Replies
View Related
Oct 26, 2011

Adding date and time. The code is listed below.

I have watched the code while running. The initial date FDateS and FDate(t) value is m/dd/yyyy (9/16/2010) and no time. FDateS has different amounts of time added to it. The issue I have encountered is that once it passes midnight, the date does not change but the time reflects the change to 00:00:00.

Public FDate(1000) As Date

Public FTime(1000) As Date

FDate(t) = CDate(Mid(FindData("sm_Sys_BatchOpenTime"), 1, 10))

For H1 = 1 To n

FDateS = FDate(H1)

For r =1 to 50

FDateS = CDate(FDateS) + CDate(FTime(r)-Ftime(r-1))

Next

Next

View 1 Replies
View Related
Nov 26, 2012

I have two columns with numbers in ranging as follows:

2

2.5

3

3.5

4

4.5

5

On the spreadsheet it looks like this:

4.5

5

4

4.5

3.5

3.5

3.5

4

3.5

3.5

3

3

3.5

3.5

What I need to show in the next column is a True where these two figures add up to 8 or more. However, the minimum in each column needs to be 4 and 4 i.e. if one column has 3.5 and the next 5 then return a value of False.

View 7 Replies
View Related
May 22, 2007

I have some great code that HalfAce provided a while back that I think will fit a project I am working on, but I can't see how to modify it to fit this one. I need to have it look at a location and provider and find the most "common" date. Then for that criteria fill in the lines with no dates with that "common" date. Here is the code that I need to modify for this

Sub FillInTheBlanks()

Dim LstRw As Long, _

DescRng As Range, _

AccntRng As Range, _

Desc As Range, _

Accnt As Range

LstRw = Cells(Rows.Count, "B").End(xlUp).Row

Set AccntRng = Range(Cells(2, "B"), Cells(LstRw, "B"))

Set DescRng = Range(Cells(2, "I"), Cells(LstRw, "I"))

View 9 Replies
View Related
Mar 23, 2009

I behind developed to a time a function of Addition with an only conditional criterion.

I would like to extend at least for three criteria, this function I function accurately as the function SUMPRODUCT alone that done in VBA.

Function VlookupAllSum(name As String, IntervalSearches As Range, IntervalReturn As Range) As Variant ' as integer para valores até 32.767

Dim Valor, Nome

Dim lin, col As Integer

Dim Total

Application.Volatile

lin = 1

col = lin

For Each Nome In IntervalSearches

If Nome = name Then

Valor = IntervalReturn(lin, col)................

View 9 Replies
View Related
Apr 14, 2006

see the attached sheet. It already has some example....I need the result of the addition in the cells of column F, at the side Say column G, in the coressponding row. e.g for cell F9, I need the result in G9, and so on. For testing, step 1. Select M+R in Col "TOI", enter some value in the pop up. step 2. Again select M+R in "TOI", enter some value in the pop up. the Col F will have some additions (e.g 1+2), for which I need the result in the corresponding next column. i.e col G.

View 4 Replies
View Related
Jun 20, 2007

I am working on a spreadsheet that matches each cell in Column B (text) with the data (text) in a constant cell; if there is a match, the data that corresponds to the data in Column B (text) will average (Column G, number) using a CSA formula, for example: =AVERAGE(IF($B$3:$B$106=A$110,$G$3:$G$106))

Now the formula above works well, only I have to update the spreadsheet, so when I add new rows the $B$3:$B$106 and $G$3:$G$106 portions are useless.

Trying to use the INDIRECT function that many people successfully use in this forum, produces a #VALUE error,

=AVERAGE(IF(INDIRECT("$B$3:B"&ROW()-4)=A$111,(INDIRECT("$G$3:G"&ROW()-4))))

View 9 Replies
View Related
Apr 12, 2008

Take a single cell in column D, and multiply it by a single cell in column E, which will equal F. Take column F, and multiply it by .02 (2%), which will equal G. Take a cell in column G, and subtract it from F, which will equal I. And this all takes place in the same row. Then have it move down to the next row, and do the same thing..... so it would basically look like this.....

A B C D E F G H I

1 D1 E1 (D1*E1) (F1*.02) (G1-F1)

2 D2 E2 (D2*E2) (F2*.02) (G2-F2)

3 D3 E3 (D3*E3) (F3*.02) (G3-F3)

For easier reading.... in each row I want it to do the following math

D*E=F

F*.02=G

G-F=I

And then do it for every row that I have data in (excluding the VERY first row). I am -COMPLETELY- sorry if I broke any rules, and am also sorry for the poor representation

View 5 Replies
View Related
Feb 17, 2014

I would like to sum the amount column of unique date that is in active status of each account.

Account Date Status Amount

11 jan 1 A 200

12 jan 1 A 5

13 jan 1 A 1000

11 jan 1 A 200

11 jan 3 A 100

12 jan 3 A 8

13 jan 4 A 1

13 jan 4 A 1

11 jan 6 I 50

12 jan 6 A 10

Below is the expected result

Account Amount

11 300 (200+100) [200 is only add once since jan 1 of 11 has appeared more than one time]

12 23 (5+8+10)

13 1001(1000+1)

View 5 Replies
View Related
Mar 7, 2012

I have entered this value into a cell on my worksheet. It is referencing a cell in another worksheet on a shared drive on my network.

='\servershare$[doc1.xls]Sheet1'!$A$1

All is fine until I re-open the document, whereby it has changed to:

='\serverusers$share$[doc1.xls]Sheet1'!$A$1

I have been advised to set the hyperlink base as \servershare$

...but this clearly does not work.

View 4 Replies
View Related
Apr 21, 2006

i have used the database from j & r solutions. i have altered it slightly to suit me. the database works fine apart from when using the find all button it will only return 4 entries. if there are more than 4 entries it returns runtime error 9.i have zipped up the code and marked where the error is shown when i debug

View 2 Replies
View Related
Oct 20, 2012

I have two columns of data in an excel sheet that are equal in size and both only contain numbers.

I'm trying to write a macros which will put both of these sets into arrays, then perform a calculation on them.

Specifically ArrayA + 3*ArrayB then put the result back into the worksheet in a new column. Below is the code I have so far.

Dim ArrayA As Variant

Dim ArrayB As Variant

Dim ArrayC As Variant

ArrayA = Worksheets("Sheet1").Range("A1:A5")

ArrayB = Worksheets("Sheet1").Range("B1:B5")

This is where things go bad

ArrayC = ArrayA + 3 * ArrayB

View 4 Replies
View Related
Mar 18, 2014

I am trying to create a shift roster for my team. My team work in general shift (GS), second shift (SS), third shift (TS). There are situations where some team members come in any of these shift but had to leave midway due to feeling well, so that should be counted as half day. This half day scenario may be in any case GS/SS/TS. I am using COUNTIF to get the sum of GS/SS/TS for each employee which is giving a whole number. I also want to incorporate 3 different variations of half day as Half Day GS (HG), Half Day SS (HS), Half Day TS (HT). My expectation is that for each Half Day only 0.5 should be added in a appropriate shift, but COUNTIF is always counting this as 1. How I can achieve this using countif or any other Excel function? Sample sheet is attached.

View 3 Replies
View Related
Feb 20, 2009

I have a workbook with calculations for a sale less the assorted fees and at the end giving the final amount from a sale.

I have noticed that some of the rows are not giving the correct amount in them.

In other words the addition of some columns in that row are not adding up correctly. It is only off by 1 cent (either over or under), but I can't figure out why.

I have the feeling that I am going to want to kick myself when someone explains this to me (I just know that I know the answer but for the life of me I can't right now).

View 2 Replies
View Related
Aug 6, 2009

you guys very kindly helped me with a spreadsheet a couple of months ago, but i now need to adapt it for another dept. I have completed as much as I can.

I need column C and E in the 'totals tab' to only calculate contract and upgrade sales respectively (found in 'service orders' tab). I also need Scott's and ash's individual sales to be calculated in corrisponding tabs. Most of the formulas are in place so just need them tweaked slightley.

View 4 Replies
View Related
May 28, 2013

I'm looking for a formula that acts the same way as the subtotal formula (revises if rows are hidden and only adds visible rows). Is there anyway to get this removal of hidden rows but for subtraction?

View 3 Replies
View Related
Jan 14, 2014

I have a command button that runs a macro to insert two new rows between row 15 and 16 no real problem (see code & sheet below), but I would like the Total Hours and Total Cost rows to include the newly added rows i.e.

Rows 16 & 17

Cell B18 now contains =B2+B4+B6+B8+B10+B12+B14+B16

and

Cell B19 now contains =B3+B5+B7+B9+B11+B13+B15+B17

If another two rows are added then Total Hours and Total Cost Cells 20 & 21 will now be

Cell B20 now contains =B2+B4+B6+B8+B10+B12+B14+B16+B18

and

Cell B21 now contains =B3+B5+B7+B9+B11+B13+B15+B17+B19

Command button Code to insert row

Code:

Private Sub CommandButton1_Click()

Const fWhat As String = "EXTERNAL"

Dim sR As Range, fR As Range, fAdr As String, nRw As Long

Set sR = Range("A1:C187")

[Code] ..........

Worksheet Below

1

Hours

170

Cost

387.99

[Code] ...........

View 1 Replies
View Related
Dec 11, 2013

I'm working on a charting application that uses Office charts. I'm wondering what are some of the main reasons people change the base unit from the default, and how common that is.

Some reasons I've identified on my own:You're comparing different monthly metrics, but they could be recorded on different days of the month.Get a zoomed-out view.Compare the max value of each month.

View 3 Replies
View Related
Dec 18, 2013

I have done many research online to cater to my require but fail to accomplish it. I need to determine the decision base on ranking of the number in the Rank column. which is than reflected in the calender. But per day basis, it needs to only be green for the top "number of quota set per day" highest ranking. I have also attached the sample for a clearer understanding

Sample.xlsx

View 4 Replies
View Related
Jul 17, 2013

We have database (attached here). I want to copy the name of candidates base on their Status to their designated tab. example Diana Longoria name will be copy to "Waiting" Tab and if I change the status to "Rejected" it will be copied to "Rejected" tab and remove name from "Waiting" tab.

View 12 Replies
View Related
Jan 12, 2009

I am working on a spreasheet that will automatically calculate the interest rate, loan to value advance, and other parameters from user inputs.

I have found a way to get the calculations to work correctly, but I have about 50 lenders to input - all with different rates and lending guidlines with respect to loan to value advances.

I am sure that I am going about it the hard way and I have no problem going at this to get it right.

I have attached the spreasheet I've started. I've only got one lender completed thus far. So if you need help sleeping at night, go ahead and see what I've done (yes it's boring).

Edit note: I don't know if using Access would make this an easier project to tackle but it is an option (I'll just have to learn

Access if that's the case - I've never used it).

View 3 Replies
View Related
Jan 18, 2010

I have a formula that calculates only seconds and frames. The frame rate is 75 fps (0-74).

e.g., 49.50 is 49 seconds 50 frames. It will not parse Minutes.Seconds.Frames, e.g., 1.49.50 is 1 minute 49 seconds 50 frames.

What my existing formula does is converts the number to all frames then converts the answer back to seconds and frames.

I need this formula to include minutes in its calculation.

A copy of the spreadsheet is here: ...

View 14 Replies
View Related