changing formula to work on filtered data

PivotMeThis

Active Member
Joined
Jun 24, 2002
Messages
341
A coworker called me and said she wanted to sum data by county and I came up with this formula for her

=IF(COUNTIF(A$2:A2,A2)>1,"",SUMIF(A:A,A2,B:B))

This would work if her data was not filtered. Currently it adds up everything whether it's visible or not.

I do not understand how to modify this formula to work on filtered data, so that it only sums the visible data.

Can anyone help me?
Thanks
Rhonda

I'm using Excel 2013
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

live_excel

New Member
Joined
Nov 23, 2016
Messages
42
Make a table with all of data.Then make again this formula.Then it will work on filtered.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,133,525
Messages
5,659,327
Members
418,497
Latest member
VAllen79

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top