T
The Wolf
If you do sum a3..........c3 then filter out what was in b3 is it possible
for the sum function to reflect a3 +b3?
tia
--
for the sum function to reflect a3 +b3?
tia
--
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
The Wolf said:If you do sum a3..........c3 then filter out what was in b3 is it possible
for the sum function to reflect a3 +b3?
I see no one else has jumped in...
I'm not sure what you're asking for. Could you add a bit to your
description? For instance: How are your filtering out B3?
T
The Wolf
I see no one else has jumped in...
I'm not sure what you're asking for. Could you add a bit to your
description? For instance: How are your filtering out B3?
If you have column a reflecting a1,a2,a3,a4 etc.
And a1,a2,a4 is gasoline but a3 is car wash
And you apply a filter so just the gasoline appears it still adds the $10
for the car wash to the total even though it doesn't appear on the sheet.
Does this make sense? I want just the gasoline sum.
B
Bob Greenblatt
Yes, it makes sense. Try =subtotal(9,range) instead of =sum(range) it willIf you have column a reflecting a1,a2,a3,a4 etc.
And a1,a2,a4 is gasoline but a3 is car wash
And you apply a filter so just the gasoline appears it still adds the $10
for the car wash to the total even though it doesn't appear on the sheet.
Does this make sense? I want just the gasoline sum.
show the total of visible cells only.
T
The Wolf
Yes, it makes sense. Try =subtotal(9,range) instead of =sum(range) it will
show the total of visible cells only.
Thank you!