Help with DSUM

[taylor99ss]

Im new to Excel programming. please pardon the ignorance.

i have two worksheets. worksheet "AA" is used to display totals with criteria from worksheet "BB" via one column. for example

Column XX
1
2
4
3
1
2
1
1
2

the above is what data is within the column.

On sheet "AA" i need to show the total of how many 1's, how many 2's etc. are within column XX on worksheet "BB".

Can someone help to code this, if i get the code for "1" working i can get the rest to work. I was thinking a DSUM would fulfill this requirement. but i cannot figure out how to identify the other worksheet, and do no understand the [sum range] requirement.

your expertise is greatly appriciated.

[royUK]

Not sure what you mean. Why o you need VBA for DSUM?

n example workbook might help

[taylor99ss]

Did I post in the wrong forum?

[royUK]

I can't tell from your question what you want, you mention programming which is VBA, but have a problem with DSUM which is a Function.

[Paul]

Hi Taylor, welcome to the forum.

You shouldn't need DSUM or VBA. You can just use COUNTIF between the workbooks (the second worksheet, 'BB', doesn't even need to be open if you put the path in the formula). Example:

Assuming:
Book1.xlsx, Sheet1: Numbers 1 through 4 are in A1:A4
Book2.xlsx, Sheet1: List of numbers is in column A

In B1 of Book1.xlsx put the formula:

=COUNTIF('C:\Excel_Files\[Book2.xlsx]Sheet1'!$A:$A,A1)

Then copy that formula down to B4 and you should have your counts. Change the path to your actual path, of course!

[taylor99ss]

Paul -

thanks for the help. but i am only using one book with multiple sheets. does your solution still apply?