Column calulation query

[broncos347]

I have two columns (AS and BV). In AS is the name of one of three Contractors (lets say A, B and C), in BV is a list of costs asigned to a particular site.

What I would like to be able to do is to add up the figures in BV but only if column AS has Contractor A listed in the cell and like wise for the other two contractors.

Hope someone can help.

Regards,

Ian.

 

[Andrew Poulsom]

Like this:

=SUMIF(AS:AS,"A",BV:BV)

You can use a cell reference in place of "A".

 

[broncos347]

Andrew,

Cheers, it's so simple when you know how.

Thanks.