Sum numbers in a column beyond a certain row, how to?
How to sum numbers in a column beyond a certain row?Message posted on the February 15th, 2012 - 1:25 AM ET
Sum with conditions
Hi all, I'd like to sum a column that contains a mix of numbers and text based on a condition that appears in a cell that is 2 rows 'down' from the number. The structure looks something like this: Week 1 Week 2... 500 Home Name1 1 1000 Home ...Message posted on the December 26th, 2011 - 1:41 AM ET
VBA for data validation in 3rd column does not run. I need help.
I have a complex program written six years ago, and I am working to update it. In the program, I am concerned about the sum of data entered into two ranges; Column A5 - 15 Column B5 - 20 Column C5 contains a simple excel formula that adds column ...Message posted on the July 30th, 2013 - 10:17 PM ET
sumif wildcard for text and numbers
Hi, I have a large spreadsheet that sums a column if there is an "x" in another column: =SUMIF($J102:$J302,"x",$AL102:$AL302) I need to change some of the "x"'s to numbers but I would stil like to sum in the same ...Message posted on the August 24th, 2012 - 8:10 AM ET
Sum of two highest numbers
Hi all, Thanks in advance for being there and helping. I'm Ok with the basics of Excel, and indeed some years ago got quite good with bits of it, but am struggling with something at home now, as I have no manual, and I haven't needed Excel for some ...Message posted on the February 23rd, 2013 - 9:48 AM ET
Calaculating a column sum from within the same query
Below is the result of a select query which generates a list of planned activities based on a crosstab, which totals the ouptut of four sections and combines them into a wek number and how many are closed this week. KeyEventWeek TotalPlanned ...Message posted on the March 8th, 2012 - 2:25 PM ET
How to ignore a column of numbers in Grand Total for rows
Hi, My pivot table has three "amount" columns for various products representing 1) 2012 sales 2) 2013 sales 3) 2012 collections Product Category Amount Bananas Sold 2012 $9,861.00 Grapes Sold 2013 $5,109.00 Nectars Paid 2012 ...Message posted on the December 15th, 2012 - 6:13 PM ET
Add numbers if cell fill is a certain color; How To?
Being old, I keep a spreadsheet of all medical events and their eventual payments to medical providers. This year we have one major category of outgo with numerous events. The amounts I'd like to single out and sum are scattered throughout the ...Message posted on the February 15th, 2013 - 10:33 AM ET
adding multiple values from matched search results
Hello. This is my first post, so forgive me if I'm in any way unclea (or overly detailed for that matter). I'm trying to write a formula that will add together all the values tha match a search criteria. I have a spread sheet that keeps track of ...Message posted on the June 7th, 2012 - 2:12 PM ET
Need help with a complicated macro (code change)
Goodday Hope someone can help me with the following macro. This is what I hop to get achieved. Column A I have numbers repeat numbers aswell that assigned to Column B Column B I have numbers 1-45 aswell thats assigne to Column A. In the following ...Message posted on the September 25th, 2012 - 5:24 AM ET
SUMIF with criteria "" & "="
I'm using excel 2007. I have 2 columns of data. A1:A8 contain various numbers only. B1:B8 contain numbers, text, & empty cells. I use the formula SUMIF(B1:B8,"<>",A1:A8). This works fine for my needs as I'm trying to sum the ...Message posted on the May 7th, 2013 - 5:38 AM ET
Formula for summing purchases and sales
a b c d `f g h i 1 date nane1 buy 34 99 2 date name1 sell 24 56 3 date name2 buy 56 99 4 date name3 buy 36 ...Message posted on the March 30th, 2012 - 3:06 PM ET
I need a macro to associate values in columns
I have a list of names in the first column which can contain one o more of the same name, and a list of numbers associated with each nam in column 2 . what i want to do is search through the names and add th corresponding numbers, so as I end up ...Message posted on the September 12th, 2012 - 2:47 PM ET
Help with SUMIFS
Hello, My first time using SUMIFS, based on what the function is meant to do, think this is the function I should be using, but just can't seem to ge it to work. I have data on my Master tab, and attempting to total on my Ship Summar tab. The ...Message posted on the February 3rd, 2012 - 3:43 PM ET