|
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 » Post Reply
|
Ian |
posted on 22nd Jul 11 at 22:05 |
Done that the sheet I got, they're all zero in those five rows, is that correct? | |
Ian |
posted on 22nd Jul 11 at 20:31 |
In S2, put | |
Gareth |
posted on 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 |
posted on 22nd Jul 11 at 19:14 |
=IF(AND(M2="",L2>TODAY()),0,SUM(N2:Q2)) | |
Gareth |
posted on 22nd Jul 11 at 19:13 |
Thanks, but it still displays the figure in S2, whether M2 is blank or not. | |
Ian |
posted on 22nd Jul 11 at 19:04 |
Can't test it here, try this. | |
Gareth |
posted on 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. | |
Brett |
posted on 22nd Jul 11 at 18:54 |
Skills | |
Ian |
posted on 22nd Jul 11 at 18:49 |
:cool: | |
Gareth |
posted on 22nd Jul 11 at 18:48 |
Works a treat! Many thanks for the speedy reply, really appreciate it! :-) | |
Ian |
posted on 22nd Jul 11 at 18:22 |
=IF(M2<>"",0,SUM(N2:Q2)) | |
Gareth |
posted on 22nd Jul 11 at 18:02 |
Not for me for my miss's i will let her type it, ta. |