Posts by auntyjack

Hi all, can u please tell if, when using the SUMIF function, if u can have more than 1 criteria?
I want the criteria to be ">=1/7/04,<=30/9/04" when I delete 1 date it works fine , when I add the 2nd date the result is 0.
Many Thanks
Happy & Safe Christmas To All

Is it possible to use a formula to have a date automatically inserted in cell B after 30 days has passed from the date entered in cell A. Until the time has passed, cell B would remain blank.
This is in an invoice spreasheet and cell B is the reminder date.
Im pulling my hair out with it.
Thanks in advance:barf:

Thanks for you help, it works like a charm.
Cheers
auntyjack:spin:

If ya follow the attached link there's some info there that might be helpful to you.
http://www.experts-exchange.co…MS_Access/Q_20736359.html
Let me know how ya go
Cheers
auntyjack

Thanks Weasel, I think the second options would be good, any hints on how to write it as Im not real good at VBA.

Hi all, can anyone tell me how to insert a row automatically depending on what is entered into a cell above; eg Y or N.

Thanks heaps
:tumble:

You can use the CONCATENATE function in front of IF, this will allow you to nest up to 39 IF functions.
Hope this might help you:)

Q: I need to change the colour of a cell dependent on what data I enter (persons initials), is there a simple way to do this?
I cant use conditional formatting as there are more than 3 conditions and Im not really good at using VBA. I have searched the web but everything is VBA.
Any help would be appreciated.
Thankyou

Thanks RLS;;)

Row 1, sorry

Could someone please advise how I can get row A to print at the beginning of each page. Row A has headings relating to the columns.

Thanks in advance
Great forum
auntyjack:)

Thanks heaps,
I had the AND between 2 ISBLANK.

Q: eg: if A1 and A2 are blank, how can I keep the cell with the formula in it blank when there is nothing in A1 and A2. Then when I enter data in A1 and A2 have the cell calculate a formula.
The formula I am currently using is
=IF(ISBLANK(A1)," ",(B1+3650)+D23-D27)
and when I add A2 into the isblank it has a hissy.
Where am I going wrong

Great forum
Thanks

Thanks heaps

Is there a way to conditional format entire rows dependent on the criteria in one cell in that row, and can it be copied down the sheet.

Thanks
Auntyjack