vba/macro for loop-based summing?

V

viveleroi0

Say I have three columns - column A is for a state code (AK, AL, etc
and column B is a hire date, and column C is a number of employee
hired in that state, on that date.

I want to find a way to perform the following type of calculation.
don't know VB but I think it needs to be coded - there is not an
function I am aware of.

ALL COLUMN B CELLS THAT MATCH OTHER COLUMN B CELLS
SUM COLUMN C
WRITE RESULT IN D1

thats kind of pseudo code, but it gets my point across. What I want i
something that groups all state codes, AK, AL, etc together and sums u
COLUMN C values for each unique state code
 
B

Bob Phillips

=SUMPRODUCT(--($B$1:$B$1000=B1),--($C$1:$C$1000))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top