Adding Columns of Data

's Computer Specifications

I have a question about adding data in selected cells.

Let's say that column "G" contains dollar values, and that column "J"
contains the text either "yes" or "no". I want to sum all the dollar
values where the adjacent cell is "yes" only.

How would I accomplish that?

Thanks,
Brian

's Computer Specifications

Try this:

=SUMIF(J:J,"Yes",G:G)

Biff

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a question about adding data in selected cells.
>
> Let's say that column "G" contains dollar values, and that column "J"
> contains the text either "yes" or "no". I want to sum all the dollar
> values where the adjacent cell is "yes" only.
>
> How would I accomplish that?
>
> Thanks,
> Brian
>

's Computer Specifications

Sir that was just what I needed, thank you Biff.

Brian

T. Valko wrote:
> Try this:
>
> =SUMIF(J:J,"Yes",G:G)
>
> Biff
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have a question about adding data in selected cells.
> >
> > Let's say that column "G" contains dollar values, and that column "J"
> > contains the text either "yes" or "no". I want to sum all the dollar
> > values where the adjacent cell is "yes" only.
> >
> > How would I accomplish that?
> >
> > Thanks,
> > Brian
> >

's Computer Specifications

You're welcome. Thanks for the feedback!

Biff

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sir that was just what I needed, thank you Biff.
>
> Brian
>
> T. Valko wrote:
>> Try this:
>>
>> =SUMIF(J:J,"Yes",G:G)
>>
>> Biff
>>
>> <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >I have a question about adding data in selected cells.
>> >
>> > Let's say that column "G" contains dollar values, and that column "J"
>> > contains the text either "yes" or "no". I want to sum all the dollar
>> > values where the adjacent cell is "yes" only.
>> >
>> > How would I accomplish that?
>> >
>> > Thanks,
>> > Brian
>> >
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding the data of two columns together.	=?Utf-8?B?Um9tYW4gQi4=?=	Microsoft Access Queries	1	12th Feb 2007 08:06 PM
adding new columns sheet with external data	=?Utf-8?B?Sm9obg==?=	Microsoft Excel New Users	0	23rd Sep 2005 08:00 PM
Adding data in two columns	=?Utf-8?B?U2hhd24=?=	Microsoft Excel Misc	3	29th Oct 2004 08:29 PM
adding columns to data table	Jimbo	Microsoft C# .NET	1	7th May 2004 05:24 PM
Adding conditional data from 2 separate columns	Drew	Microsoft Excel Misc	2	6th Jan 2004 10:55 PM