We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

****Bank Holiday Chat! May 22 and onwards! Whoooop!***

1…910121415…70

Comments

  • redsquirrel80
    redsquirrel80 Posts: 12,457 Forumite
    I think you can use SUM and IF separately for multiple conditions? Sorry got to dash but hope you get it sorted... if in doubt try Excel Help! :D

    Have a lovely long weekend everyone and I'll catch up with you on Wednesday if not before xx
    Debt@16.12.09 £10,362.38, now debt free as of 29.02.2012.
    "I cannot make my days longer so I strive to make them better."
  • Burlesque_Babe
    Burlesque_Babe Posts: 17,547 Forumite
    Part of the Furniture Photogenic Combo Breaker
    seems I was wrong to be cynical - which of the 5 available interview slots would I like? I've chosen to be first at 10.20. Interviews are only 40 minutes long, not sure if I was first to be phoned but certainly not last....I gently probed about the reason I'd emailed and I had an apology for the tight turnaround.......I must be getting old be getting so cynical :rolleyes:
    :D"Stay Wonky":D

    :j:jBecome Mrs Pepe 9 October 2012 :j:j
  • Burlesque_Babe
    Burlesque_Babe Posts: 17,547 Forumite
    Part of the Furniture Photogenic Combo Breaker
    edited 22 May 2009 at 4:32PM
    Toto - no, no chance of a full time job unless I get something in the merger. Most posts have a default person for them, there are about 5 new posts. 3 are full time, 2 I don't have the necessary qual. for. The only full time post is one I could do and is relevant to my past career but depends on when it they go ahead (could be many months from now) and whether anyone else is seen as more suitable. There may be someone from the other organisation who may lose their post, so would get this one instead. Other than that, my best chance is 2 low grade part time posts, adding up to about 17k, which is just not enough to live on for a single salary with a mortgage in this part of the world.
    :D"Stay Wonky":D

    :j:jBecome Mrs Pepe 9 October 2012 :j:j
  • InkyCats20
    InkyCats20 Posts: 1,282 Forumite
    Part of the Furniture Combo Breaker
    becky_rtw wrote: »
    Inky it depends - if you have excel 2007 you can use SUMIFS but any earlier and you need to do this I think:
    =SUMPRODUCT(B2:E2,--(B3:E3>3%),--(B4:E4>=2%))

    Where:
    1. array1 = B2:E2 - This is the array from whom
    2. array2 = –(B3:E3>3%) - This is the first condition
    3. array3 = –(B4:E4>=2%) - This is the second condition
    Does that help?? Try googling SUMPRODUCT and see what help there is perhaps??

    Thank's Becky - I'll give that a go, I have excel 2007 at home but at work we're still on 2003 :rolleyes:
    Don't Take Life too Seriously - Nobody gets out alive :rotfl:
  • Burlesque_Babe
    Burlesque_Babe Posts: 17,547 Forumite
    Part of the Furniture Photogenic Combo Breaker
    hey.............this is fab news.........I can now take my lappy to the park - with Charlie as I do normally - and get free wi-fi connection to keep in touch with you lot!! :j:j:j

    http://www.poole.gov.uk/news/ref:N4A166EE907BF5
    :D"Stay Wonky":D

    :j:jBecome Mrs Pepe 9 October 2012 :j:j
  • Toto
    Toto Posts: 6,680 Forumite
    Part of the Furniture Combo Breaker
    Burlesque_Babe wrote: »
    hey.............this is fab news.........I can now take my lappy to the park - with Charlie as I do normally - and get free wi-fi connection to keep in touch with you lot!! :j:j:j

    http://www.poole.gov.uk/news/ref:N4A166EE907BF5

    OOh get you with your fancy park :)

    our council only grudgingly supply grass
    :A
    :A
    "Everyone is a genius. But if you judge a fish on its ability to climb a tree, it will live its whole life believing that it is stupid" - Albert Einstein
  • Snaggles
    Snaggles Posts: 19,503 Forumite
    Toto wrote: »
    our council only grudgingly supply grass

    Ooh get you with your fancy park - you have grass?? :)

    Our council only grudgingly supply mud, teenagers and bottles of White Lightening... :D
    "I wasn't wrong, I just wasn't right enough."
    :smileyhea
    9780007258925
  • Doomcow
    Doomcow Posts: 1,729 Forumite
    yeeeeeeeeeeeeeeeeah

    OH back!!!!!!!!!!!!!!!!!! :D:D:D:D:D:D:D:D
    Mr & Mrs Doomcow Wedding Fund: £10200/£18000 (by 04/2012) (spent £2000)
    meiow meiow purr meep merp purr urble purrup :)

    requires further financing
  • Snaggles
    Snaggles Posts: 19,503 Forumite
    Doomcow wrote: »
    yeeeeeeeeeeeeeeeeah

    OH back!!!!!!!!!!!!!!!!!! :D:D:D:D:D:D:D:D

    What are you doing on here then silly - shouldn't you be 'busy'?! ;):p:D
    "I wasn't wrong, I just wasn't right enough."
    :smileyhea
    9780007258925
  • Bunnyinthelights
    Bunnyinthelights Posts: 15,278 Forumite
    Evening,
    Off to the cinema tonight with DH...
    Empty pockets never held anyone back, only empty heads and empty hearts can do that -Peale
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.1K Banking & Borrowing
  • 253.5K Reduce Debt & Boost Income
  • 454.2K Spending & Discounts
  • 245.1K Work, Benefits & Business
  • 600.7K Mortgages, Homes & Bills
  • 177.4K Life & Family
  • 258.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture