Sum and filter

[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
--

 

[JE McGimpsey]

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?

 

[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.

 

[Bob Greenblatt]

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.

Yes, it makes sense. Try =subtotal(9,range) instead of =sum(range) it will
show the total of visible cells only.

 

[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!