Make a donation
« previous next »
Pages: [1]   Go Down

Author Topic: VERY Rusty with MS Excell - need some help!  (Read 750 times)

Offline Degudodger

  • Just look at my post count
  • ******
  • Thank You
  • -Given: 53
  • -Receive: 86
  • Posts: 1547
    • Flickr
VERY Rusty with MS Excell - need some help!
« 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?
Logged
2016 Mk7 Golf GTD - Reflex Silver with stuff.

VCDS Hex+Can - Will code for beer!

Offline Janner_Sy

  • Just look at my post count
  • ******
  • Thank You
  • -Given: 62
  • -Receive: 113
  • Posts: 5392
Re: VERY Rusty with MS Excell - need some help!
« Reply #1 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.
Logged

Offline rich83

  • Just look at my post count
  • ******
  • Thank You
  • -Given: 165
  • -Receive: 802
  • Posts: 13444
    • MK5 Golf GTI
  • My Ride: https://www.mk5golfgti.co.uk/forum/index.php?PHPSESSID=n90h6bf733d2dei08kgc1ft3s9&/topic,19740.0.html
Re: VERY Rusty with MS Excell - need some help!
« Reply #2 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
Logged

Offline chungster

  • Just look at my post count
  • ******
  • Thank You
  • -Given: 6
  • -Receive: 33
  • Posts: 1963
Re: VERY Rusty with MS Excell - need some help!
« Reply #3 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.
Logged

Offline Degudodger

  • Just look at my post count
  • ******
  • Thank You
  • -Given: 53
  • -Receive: 86
  • Posts: 1547
    • Flickr
Re: VERY Rusty with MS Excell - need some help!
« Reply #4 on: September 23, 2013, 07:56:05 pm »
Rich, Chungster.

Thanks a million  :happy2:
Logged
2016 Mk7 Golf GTD - Reflex Silver with stuff.

VCDS Hex+Can - Will code for beer!
Pages: [1]   Go Up
« previous next »