MK5 Golf GTI

General => Random Chat => Topic started by: Degudodger on September 23, 2013, 11:39:34 am

Title: VERY Rusty with MS Excell - need some help!
Post by: Degudodger on September 23, 2013, 11:39:34 am

Having not used Excel properly for a number of years I have completely forgotten basic formulae!!

I want a conditional SUMIF based on the criteria of a column. So for example Column C to show the total of column “A1:A10” but only if column B contains “YES”

Also, any recommendations for UK based Excel help forums?

Title: Re: VERY Rusty with MS Excell - need some help!
Post by: Janner_Sy on September 23, 2013, 12:16:03 pm

Sounds stupid, but google it, there are masses of guides on formatting in excel.

Im not sure it can be done through conditional formatting, but im keen to know how to do this as well as it woud make my job alot easier.

Title: Re: VERY Rusty with MS Excell - need some help!
Post by: rich83 on September 23, 2013, 12:18:16 pm

=SUM(IF(B1="YES",A1:A10))

So A1-A10 is the data.... and B1 is the trigger cell

Title: Re: VERY Rusty with MS Excell - need some help!
Post by: chungster on September 23, 2013, 05:14:49 pm

I would do =sumif(B:B,"YES",A:A)

That will sum up every cell in column A that has a YES in Column B beside it.

Title: Re: VERY Rusty with MS Excell - need some help!
Post by: Degudodger on September 23, 2013, 07:56:05 pm

Rich, Chungster.

Thanks a million  :happy2: