# sum

1. ### Combine and Sum Lookups across multiple rows using an array formula

Hi, I need to convert several currencies across multiple rows into GBP by looking up a conversion table and then provide the sum in GBP. I haven't been able to come up with an elegant formula (an array type formula maybe) to keep it short and simple. for the SUM in GBP, I've got the...
2. ### PowerPivot CALCULATE SUM

Hi, would appreciate any help with this, I'm trying to do a calculate sum if in PowerPivot, example of how it workls in Excel below, but am unsure how to replicate in PowerPivot. Thanks in advance for any help. Gav.
3. ### HELP - Complex SUMIF - SUM of PRODUCTS of two cells IF another cell is within a specified date range

Hi all, I am new to this forum and so apologise if I have posted this to the incorrect thread, etc. What I am trying to do is quite simple in theory, but I cannot get a variation of SUMIFS, SUM and IF to do the job. The context is this: I am looking to create a resource for a client couple...
4. ### For every cell value that contains string, sum another cell

I am not sure the best way to describe this. I have a spreadsheet with the following headers: Date; Ticker; Transaction Type; # of Shares; \$ / Share; Cost Under transaction type, the cell will contain "Buy" or "Sell". I would like to make two additional headers that are "Sum of Buy"...
5. ### Pivot Table, Value criteria set to sum, hide zero's

I have a data source that deals with items going to customer on deposit. If they take one widget, there is a sale of 1, when they return the widget, there is a sale of -1. resulting in a Zero. I have attached a picture. Over hundreds of customers and thousands of transactions, we can be...
6. ### Need help to sum live data in 2 week increments.

My goal is to understand which two week increments of a marketing campaign were most/least effective. Column A: live data for a marketing campaign (leads generated) Column B: Sum up the live data up until 2 weeks after the start date of the campaign. After the 2 weeks is complete, I would...
7. ### SUMPRODUCT IF value equals

Hello, could you please kindly help me with the below, to make it so that it'd only consider values for the calculation if the corresponding value in column 'A' = "XX", and instead of specifying the range, sums up all the matched values in a given column? Please also note that values start in...
8. ### hh:mm:ss average problem

hello, I have data that present at hh:mm:ss eg 00:01:52 but when I try to average I get the DIV error and when I try to sum it comes out as 00:00:00 I have tried the different formatting but nothing changes.
9. ### SUM IF Duration Is Between Certain Values

Hi All! Could you please kindly advise as to how to sum duration values that fall between certain ranges? My custom format is set to [h]:mm and cannot be changed. Let me illustrate what I'm trying to do with an example. Columns A & B usually contain 9:00 & 17:30 respectively, however, at...
10. ### Find the combination that gives the minimum sum of squares

I have a number of vectors A,B,C,...etc as a pair of numbers such as below: x y 1 A 2 4 2 B 5 6 3 C 3 9 I want to list or at least find the combination that produces the minimum x^2 + y^2, by taking combinations by 2 or 3 vectors. I've tried solver unsuccessfully...
11. ### Sum of alternate columns with subtotals

Hi I have a report which pulls values from 2 sources (13 from each) for each month of the year, so 312 columns in total. For each line, I need to subtotal each source per month to compare these totals, and also get the annual totals for comparison. How can I get this? Thanks in advance.
12. ### VBA for total and subtotal

Hello, I have a spreadsheet with column I where there is a lot of data. I have the 1000 which is the sum of the 2x500 (bold) The 2x500 are the sum of the data (first one is 200 =300 and second one is sum of 5x100) I would need a VBA that would populate the formulas taking in consideration the...
13. ### Counting distinct values as well as giving a sum

Hello, I am after some assistance in getting some information out of my database which is causing me some problems. My data shows each individual journey that a truck has taken and I am trying to show the number of journeys each truck did in a given county on a given day and a given shift...
14. ### VBA Insert SUM formula not result of SUM

Hi Folks, I have invoice data separated with blank lines between invoice numbers and I'm currently using the following code which gives me the result of summing up the line items of a given invoice and it works fine. But what I would like to do is actually insert the sum formula for the rows...
15. ### Sum if Question

I'm not sure if this is possible, however I am trying to sum a row, but if the sum value drops below a 0 it should just be 0. If it's a positive, it should return the value of the row. =IF(A3="","",SUM(B3:C3))+D2 It's a daily continuing total so I just added the day before to the next day if...
16. ### Generating random numbers / Sum with a command button

Hi, I need to create a code that will generate random numbers at the click of a command button "start" until the person click another command button "stop"..... the numbers will appear on the form and once stopped, it will provide the overall sum of all numbers generated can someone help me...
17. ### VBA Code for Summing Data Above total until a blank row

Hi All, I'm working on a project to automate a manual process currently in place and am struggling with one piece of the macro puzzle. I have a spreadsheet with data across several columns and rows, separated by a blank row with totals underneath each data category. The totals are generated by...
18. ### Complete my formula...if function with multiple criteria (or alternative ideas)

Please can someone correct my formula, I feel like I am so close but struggling to get it right. Below is as far as I have got but I just cant find the right expressions for it to work correctly. I have attached a picture of the document I am working with for your reference...
19. ### Sum and Match Combined

Hi, I want to sum rows using the match function. I need the match function to figure out what row to sum based on the value in column A then skip 2 columns and sum row X columns D-F. Any ideas? Below is an example. Column A Column B Column C Column D Column E Column F Row 1 # Street...
20. ### Sum Monthly Data to Quarterly

Trying to Sum monthly data from a column in a different sheet to a quarterly output in a row on my summary page. Anybody know of a formula that I could use to do this? Thanks!