totals

i use this formula below =SUM(C62:CV62)-(CX62) It checks hour totals from where it starts. This formula is always under the name Check Hours and ends above that word Before Overall Totals=. What I am trying to do is every time I shift the 2 columns to go to the next which will be CW & CX . I...

Good day all, Is there a formula that will sum cells that are specific to color? We are sent data from our customer that is specifically identified by color. When we transfer that data to our spread sheet we want to see the all the totals at the top of the page rather than subtotaling and...

I need to find the row number of the text "Total" in column A. Note that there is also the text "Totals" in the rows above which should be ignored. Thanks for any help on this.

So, i want to get totals using sumif but if i want to exclude a set of cells from totals based on criteria, how do i do that? Ive got the sumifs total, but i want to exclude "not ok" from the total. Most likely a combination of sumifs & if, but i cant get it. Please see table below <tbody>...

<tbody> hours complete avg hr 1 85.5 204 2.39 2 133 90 0.68 3 175.25 294 1.68 why are these averages different? 4 131.5 383 2.91 which one is the true average? 5 125 469 3.75 6 143.5 592 4.13 total 793.75 2032 2.59 or 2032 dived by 794 equals...

I have a forecast sheet for Purchase order usage. I have a beginning balance in column F. I have Actual Cost from G1 to L1. I have forecasted totals from M1 to R1. I have current PO Balance in U1. i am looking for a formula that takes forecasted Month over Month totals and tells me remaining...

I have a dynamic pivot table that will shrink and grow depending on the data. On average there are 1000 rows of data. I wish to display the Grand Totals at the top of the report. I am unable to use the trick of creating an additional field within the table with the same data for all rows and...

Hi, I am trying to figure out a way to keep running totals of my daily tasks to replace my current paper records. I am testing a workbook I setup, but the process seems cumbersome (I started in IT as a data entry clerk and dislike using my mouse). Here is a small sample of my data as it...

So I have a pivot table and one column is years. Data starts with April 1, 2016 and goes through March 31, 2018. It has each month shown and then totals for each year. How can I replace those totals so that it shows per 12 month period instead? So instead of 2016, 2017 and 2018 totals. I...

Hi, I have table ranging from A1 to J5. A1 to J1 are headers. A6 to J6 are totals. I need a button that adds new last row to table. For example first I need to add row 6 and push totals to row 7 and so on. Thank you

Hi, Is it possible to use Indirect & frequency formula together? Need a formula to count the score totals from sheet2 using Ref "Sheet2H:H" Thank you. <colgroup><col width="64" style="width: 48pt;" span="3"> <col width="114" style="width: 86pt; mso-width-source: userset; mso-width-alt...

I have a sheet with one column showing the quarters and another column the revenues. there are multiple rows with data, how can I show the totals per quarter in a separate sheet? What formula could I use?

I am current at a loss and in need of help. Below is the data I am trying to count from. I currently have the count function of: =COUNTIF(G1,"<> 0") in column H. This works if there is a balance in column G. I wanted to take it a step farther and basically if G is zero then if F is "114"...

Ok, not so sure why this is harder than it seem but noting is working. I have been all over this BB and others and nothing works I have tried copying just adding the values. I have tried declaring variables I have tried something with LEN in it and several other things I can think of but...

I have excel 2010 i have changing rows when a row is inserted. i have 2 tables. is there a way i can have my totals formula to stay the same when a new row is inserted.

Good day. I have been using Excel for 20 years, but this one is strange. I recently updated to Excel 2016 on Windows 10 Home. I have a workbook that I added a new worksheet to that holds parameters that will change every year. the new worksheet is called Presets. One of the entries in...

Hi - I'm using this code to parse data from another sheet and it's working perfectly. However, I want to also add a total of each column from H to AM on each newly created worksheet. Is this possible? My issue with other codes I've found is that you have to specify the names of worksheets or...

Hello- I'm still new to VBA and do most of my coding with recording and modification so I may need a LOT of help here. I have a table that lists Part #, forecast values, and dates-in-months. I need to find an easy way to convert the months and values to weeks. E.g. P0421 - 2018M03 - 30000...

<!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Version>14.00</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello I have a workbook called ‘DataEntry.xlsm’ where the user will enter daily sales. This...

Greetings, I need help with something I was tasked to do for work. I'm familiar enough with Excel to know this is possible, but not sure how to develop the formula. I have a list of items with prices that I want to group into 4 similar totals. For example, I may have 12 items (no...