Need help from excel gurus - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » Need help from excel gurus

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Gareth

Member

Registered: 2nd Mar 00
Location: Derby, Drives: EVO VIII MR & pug 308
User status: Offline

22nd Jul 11 at 18:02

Not for me for my miss's i will let her type it, ta.

I want cell S2 to add up cells N2:Q2 only if cell M2 is blank. When I type a date in M2 I want S2 to be 0. It's an accounting spreadsheet and I need an overdue column. If there's an easier way of doing this then please tell me!

[Edited on 23-07-2011 by Gareth]

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

22nd Jul 11 at 18:22

=IF(M2<>"",0,SUM(N2:Q2))

Gareth

Member

Registered: 2nd Mar 00
Location: Derby, Drives: EVO VIII MR & pug 308
User status: Offline

22nd Jul 11 at 18:48

Works a treat! Many thanks for the speedy reply, really appreciate it! :-)

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

22nd Jul 11 at 18:49

Brett

Premium Member

Registered: 16th Dec 02
Location: Manchester
User status: Offline

22nd Jul 11 at 18:54

Skills

Gareth

Member

Registered: 2nd Mar 00
Location: Derby, Drives: EVO VIII MR & pug 308
User status: Offline

22nd Jul 11 at 19:01

Sorry to be a pain but missed a piece of the puzzle, I also need it to do if L2 is passed todays date and M2 is blank, add up the other columns. Is this possible? Thanks.

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

22nd Jul 11 at 19:04

Can't test it here, try this.

=IF(AND(M2<>"",L2>TODAY()),0,SUM(N2:Q2))

Gareth

Member

Registered: 2nd Mar 00
Location: Derby, Drives: EVO VIII MR & pug 308
User status: Offline

22nd Jul 11 at 19:13

Thanks, but it still displays the figure in S2, whether M2 is blank or not.

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

22nd Jul 11 at 19:14

=IF(AND(M2="",L2>TODAY()),0,SUM(N2:Q2))

Not sure and no way to test here, heading home in a minute I'll have a proper read of what you need.

Gareth

Member

Registered: 2nd Mar 00
Location: Derby, Drives: EVO VIII MR & pug 308
User status: Offline

22nd Jul 11 at 19:23

Tried the change but still the same. I'm not very good with this :-) Instead would be better is if L2 is passed the date and M2 is empty, display what is in J2 in S2. Thats the one, if possible. Really appreciate your help, if you can send me your e-mail address I will paypal you some money across for your time.

Thanks again.

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

22nd Jul 11 at 20:31

In S2, put

=IF(AND(L2 > TODAY(),M2 = ""),J2,0)

If that doesn't work email me some rows from the sheet to ian@corsasport.co.uk

Ian

Site Administrator

Registered: 28th Aug 99
Location: Liverpool
User status: Offline

22nd Jul 11 at 22:05

Done that the sheet I got, they're all zero in those five rows, is that correct?

Ideally need a few different rows with different outcomes, one where it's not paid, one where it's not due and not paid, one where it's overdue etc.

If the formula doesn't concern the earlier columns you can get rid of those as well to email it.

New Topic

New Poll