formula help please

G

Guest

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?
 
D

David Biddulph

Formatting doesn't change the value in a cell. If you want to do that, use
a formula.
 
G

Guest

Yes formula , i think thats what i meant to ask. I just confused myself with
saying formatting . doh
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to format 5
adding/omitting/all the values prior to todays date 2
Conditional Format 3
Formula Subtracting dates to come up with number of days 3
Lists - Probably Easy ? 3
HELP needed to remove 2nd spreadsheet within a workbook 3
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Conditional Formatting - Times 1

Top