Hi,

A simple problem but a difficult solution (at least for me).
I have two columns. In column A there are different codes that arrive multiple times and that are not sorted, in column B there are numbers.

What I would like to have is simply a new table with a sum of the numbers grouped by each single code. The codes should appear in a specific order.

Has it something to do with the database function DBSUM, or should everything be programmed?

Many thanks,
Wim

Use the worksheet function SUMIF. have a look in help (F1) if you don't know how to use it.

Maccas

Just to add it to maccas

Use the evaluate like:

Function Evaluate_Usage()

sFN = "=SUMIF(A5:A7,>200,A7:A8)"

Evaluate= Evaluate(sFN)

End Sub

This will return the value

Cheers
Shasur



http://www.vbadud.blogspot.com

thanks a lot,
Wim