Conditional total

[Graham]

Could someone please help with a formula that I would need to make the
following work.

A - B - C
1 - Nuts - £1.50 - Bought
2 - Bolts - £1.50 -
3 - Washers - £0.50 - Bought
4 - Total - £2.00

I would like a formula that looks at column B and totals it up only if the
word 'Bought' appears in column C.

Many thanks,

Graham.

 

[macropod]

Hi Graham,

Try:
=SUMIF(C1:C4,"Bought",B1:B4)

Cheers

 

[Graham]

It worked fine, many thanks.

Hi Graham,

Try:
=SUMIF(C1:C4,"Bought",B1:B4)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Could someone please help with a formula that I would need to make the
following work.

A - B - C
1 - Nuts - £1.50 - Bought
2 - Bolts - £1.50 -
3 - Washers - £0.50 - Bought
4 - Total - £2.00

I would like a formula that looks at column B and totals it up only if
the word 'Bought' appears in column C.

Many thanks,

Graham.