sumif range to end of data
Thanks Bob!
"Bob Phillips" wrote:
Why not just
SUMIF(A:A,A9,J:J)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Ian Elliott" wrote in message
...
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.
|