Conditional total

's Computer Specifications

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.

's Computer Specifications

Hi Graham,

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

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

"Graham" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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.
>

's Computer Specifications

It worked fine, many thanks.

"macropod" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Graham,
>
> Try:
> =SUMIF(C1:C4,"Bought",B1:B4)
>
> Cheers
> --
> macropod
> [MVP - Microsoft Word]
> -------------------------
>
> "Graham" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.
>>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count total cells if they are a certain color-reverse conditional	Grams	Microsoft Excel Worksheet Functions	1	5th Mar 2010 06:39 PM
Conditional Format: % of total	AussieBec	Microsoft Excel Worksheet Functions	4	27th Jun 2009 08:01 AM
Excel 2002 : How to conditional format the Sub Total Table ?	=?Utf-8?B?TXIuIExvdw==?=	Microsoft Excel Misc	4	18th Sep 2007 03:06 PM
Conditional Total in a Cell	=?Utf-8?B?TG9yaU8=?=	Microsoft Excel Misc	2	12th Aug 2006 08:01 PM
conditional report total	=?Utf-8?B?SGFycnk=?=	Microsoft Access Reports	1	25th Oct 2003 05:31 AM