Make a donation

Author Topic: VERY Rusty with MS Excell - need some help!  (Read 781 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?
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.

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=eapfbm47rflr8k03ke4hv4qkn5&/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

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.

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:
2016 Mk7 Golf GTD - Reflex Silver with stuff.

VCDS Hex+Can - Will code for beer!