Thanks for any help.

I use a SUMIF function to sum values based upon a label in another range. Is

it possible to use a range that implies till the bottom of the data? There is

something like that in Visual Basic, I believe it is range.XlUp or

range.XlDown. I change the range not too often, so it is not a big deal, but

I would like to make it so it is automatic.

The formula I use now is:

SUMIF(A$2:A$991,A9,J$2:J$991)

which is inside:

=J9/SUMIF(A$2:A$991,A9,J$2:J$991)*IF(A9="BEUL",Adj!X$3,IF(A9="FEUL",Adj!X$4,IF(A9="AUL",Adj!X$5,"ERROR!")))/N9

I figure maybe there is something like:

SUMIF(A$2:A$END,A9,J$2,J$END)

or something like that?

Thanks for any help.

## Bookmarks