dsum

Hi - I was wondering if there is a way to make DSUM work with using multiple criteria possibly including an indirect cell reference. What I'm trying to accomplish is something like this: =DSUM('database',field,A3&L2:L4) I would like A2 to change as I copy the field down the column, the...

I am using the following formula to pull specific data out of a table based on the criteria 1Due through 26Due. Is it possible to rewrite the formula into one master formula from which I can reference and add 1 to the #Due value...

Hi guys, I'm wondering whether its possible to set up the selection criteria relating to a databse formula horizontally (i.e. in cells A1 and B1) rather than vertically (in cells A1 and A2)? It would be very helpful for my model given my dsum / dmax formulas run down a page (so at the moment...

Hi, I am using Dmax, Dsum formulas to sum the values (in column A) associated with a given serial number (where the serial numbers are in columns B, C,......). The strange outcome I get is that for a given serial number "UMC1", my summed values include those associated with serial number UMC1...

Hi, I have to use DCOUNTs to provide month by volumes for different sets of criteria. I'm looking to create a more elegant solution than having for each of the 12 volume criteria their own set of conditions for each month (12x12 sets of criteria) so I was hoping to have 12 sets of criteria and...

DELETE THREAD, I feel like an idiot, I figured it out....! But see, this is why I figured it out, had to post something about it first, LOL SORRY Message board!

Can anyone give any recommendations as to what would be best approach when I have to calculate partial sums to hundreds of cells from dataset of tens of thousands of rows? My data is pretty straightforward, one sheet, 8 columns and lots of rows. Two of the columns are used as index to help in...

This one might be easy for you guys, but i've been having trouble, i'm fairly new to excel. My data looks like this: fairly random entries date ______ name ___ cost 5/7/2010 __ girl1 ____ $510.00 5/12/2010 _ guy2 ____ $1,469.00 5/3/2010 __ guy1 ____ $433.50 3/29/2010 _ guy1 ____ $433.50...

<TABLE style="WIDTH: 268pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=357><COLGROUP><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have been trying to figure out a way to do this, and so far have failed miserably. I can't seem to develop an array function that works, and my VBA is not up to scratch enough to create...

Hi folks, I've been searching hard for an answer to this but cannot figure it out. I'm hoping your genius minds will have the solution to this. I'm in the process of updating a 123 sheet to Excel. I have the following data; Column E = Opportunity Column F = Row Column G = Amount Column H = Curr...

I have a list of products and units. I used the DSUM function to sum the specific product units. I place the product name in the criteria field of the DSUM function. I have 10 DSUM funtions with 10 different criteria areas and a different product name. Wanted to see if I could place the DSUM...

I have a long column of data, in which I need to sum specific data points in between other data. So the column looks like this <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT...

Hi Everyone, I'm using the following: =DSUM(INDIRECT('Team List'!A2&"!$A$2:$d$100"),"Duration",$AN$3:$AO$4) where 'Team List'!A2&"!$A$2:$d$100 results in the following data: Date Start End Duration 1/12/2008 13:00 14:00 1:00 1/13/2008 13:00 14:00 1:00 1/14/2008 13:00 14:00 1:00 1/15/2008...

I need to find a way to speed up the calculations of DSUMs. I have created workbook that has two different tabs with downloaded data from a system query. The DSUMs, based on three criteria, review that downloaded data and show the results. I have 5 tabs full of DSUM formulas. Each tab as...

I have a database with 5 rows and 4 columns. Let's say that the rows are positions on a basketball team in order down 1-5 (PG, G, C, PF, F) and the columns are colleges in order across A-D (UCLA, Michigan, Duke, North Carolina). Is there a way (without using VBA) that I could search and...

I've been using CSE formulas (primarily countif and sumif style) in a pretty huge budgeting and forecasting file. The file is getting out of control in terms of calc times, etc. I've been doing some reading up on DSUM and it looks like it could save a ton of processing time, but I fear it won't...