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
Bookmarks