Excel Lookup or If statement? 1

[mtnclark]

Hi,

Could anyone help me with this problem I have in Excel

I have 3 columns

Headed like so:

A B C
PostNo Instances BB1
BB1 5 10
BB2 6
BB1 5

and so on

What I want to do is to sum the number of instances in column B that appear with the value BB1 in colum A and to place this value under Column C, in the above illustration the value 10.

any help would be appreciated,

Regards,

Marty

 

[gizmo1973]

Have you tried a Pivot table?

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[KenWright]

Take a look at the following thread

thread68-965228

very similar need and solution

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------