L
laura.reid
Not an avid excel user but do program some in access...as
a matter of fact the spreadsheet I'm using was made from
access by me, but when I convert the report to an excell
document it loses my subtotals...so here I am with my
question...
I want to subtotal the AUTH column for each change in
TITLE, but do not count AUTH if RMK = 89, 90, or 92.
So this is what I have as code using the conditional sum
wizard, but I find myself having to cut and paste at each
change in TITLE and editing the formula to fit the new
range....tedious...is there a better way?
{=SUM(IF($N$17:$N$23<>90,IF($N$17:$N$23<>89,IF
($N$17:$N$23<>92,$L$17:$L$23,0),0),0))}
Thanks
a matter of fact the spreadsheet I'm using was made from
access by me, but when I convert the report to an excell
document it loses my subtotals...so here I am with my
question...
I want to subtotal the AUTH column for each change in
TITLE, but do not count AUTH if RMK = 89, 90, or 92.
So this is what I have as code using the conditional sum
wizard, but I find myself having to cut and paste at each
change in TITLE and editing the formula to fit the new
range....tedious...is there a better way?
{=SUM(IF($N$17:$N$23<>90,IF($N$17:$N$23<>89,IF
($N$17:$N$23<>92,$L$17:$L$23,0),0),0))}
Thanks