How to set up an automatic SUMIF function

  • Thread starter Thread starter yalex
  • Start date Start date
Y

yalex

I am trying to automatically sum all values with the same account ID.
I’ve tried using the SUMIF function but that required me to specif
what the account ID I would like it to search for. I would like th
macro to automatically search within a specific column and whenever i
finds a duplicated account ID, to sum the values of the duplicate
account ID. For example, if there are two account 900, one displayin
a positive 50 and the other a negative 25. I would like it to su
those two numbers together so that I only have one row showing fo
account 900.

Any help is much appreciated.

yale
 
select the IDs with the first cell at the top being a header like ID, and
then do Data=>Filter=>Advanced Filter, choose copy to another location,
leave criteria blank, check the box for Uniques.

Click OK and you will get a unique list of Account ID's.

now put your sumif formula next to this

assume these are in column M and formula in N, original data with ID's in A
and column to Sum C

in N1
=sumif(A:A,M1,C:C)

and drag fill down next to your values.
 
Back
Top