want to sum based on filter values

[KiKi]

I want to sum data of a filed based on what dates are chosen. e.g. if Dec, Jan is selected from filters then data corresponding to those months should be summed.

Is there any way to do that?

Thank You

 

[Luke M]

If you use the SUBTOTAL function, you can have it ignore hidden rows.
So, if you wanted to sum a column, would be something like:
=SUBTOTAL(9,B:B)

 

[Chihiro]

Alternately, format your data as table and add Total Row.

 

[KiKi]

Alternately, format your data as table and add Total Row.

this is a pivot table... data comes from database. How subtotal will work? when i wanted to have summed value in one field of same pivot table?

Thank You!

If you use the SUBTOTAL function, you can have it ignore hidden rows.
So, if you wanted to sum a column, would be something like:
=SUBTOTAL(9,B:B)

this is a pivot table... data comes from database. How subtotal will work? when i wanted to have summed value in one field of same pivot table?

Thank You!!

 

[Chihiro]

How is your Pivot organized?

If Grand Total, it will automatically adjust with filter.


It'll help if you can upload sample of what you are looking for.