Hi.

I need to sum some numbers and all these are linked to accounts.

Lets say I have accounts in column a:

4001
4002
...
4998
4999

and I want to sum values from column b in groups ranging from eg.
4230-4239, where the boundries of these ranges are defined elsewhere.

The accounts are ussually ground in 10s, i.e. from 4230 to 4239 is
related to the same "thing".

=sumif(col a, Rangeproblem, col b)

How do I solve the range problem?

/Møller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=573914