Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help please
I have a list of invoices that have a colume of dates , then a colume of
amounts . I can conditional format it so that if its more than 30 days then it changes the date to red. but is there a way of formating it so that it adds up what is due? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help please
Hi,
Have a look here on how to sum coloured cells http://www.xldynamic.com/source/xld....r.html#summing Mike "karen" wrote: I have a list of invoices that have a colume of dates , then a colume of amounts . I can conditional format it so that if its more than 30 days then it changes the date to red. but is there a way of formating it so that it adds up what is due? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help please
Formatting doesn't change the value in a cell. If you want to do that, use
a formula. -- David Biddulph "karen" wrote in message ... I have a list of invoices that have a colume of dates , then a colume of amounts . I can conditional format it so that if its more than 30 days then it changes the date to red. but is there a way of formating it so that it adds up what is due? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help please
Yes formula , i think thats what i meant to ask. I just confused myself with
saying formatting . doh "David Biddulph" wrote: Formatting doesn't change the value in a cell. If you want to do that, use a formula. -- David Biddulph "karen" wrote in message ... I have a list of invoices that have a colume of dates , then a colume of amounts . I can conditional format it so that if its more than 30 days then it changes the date to red. but is there a way of formating it so that it adds up what is due? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help please
Assume your dates are in column A and amounts in column B and that you
have 100 rows in your range. This formula (in C1 ??) will give you the total amount that is more than 30 days old compared with today's date: =SUMPRODUCT((A1:A100<TODAY()-30)*(B1:B100)) Hope this helps. Pete On Nov 20, 12:40 pm, karen wrote: Yes formula , i think thats what i meant to ask. I just confused myself with saying formatting . doh "David Biddulph" wrote: Formatting doesn't change the value in a cell. If you want to do that, use a formula. -- David Biddulph "karen" wrote in message ... I have a list of invoices that have a colume of dates , then a colume of amounts . I can conditional format it so that if its more than 30 days then it changes the date to red. but is there a way of formating it so that it adds up what is due?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|