If Formula to calculate dates and amounts

[lzweifel]

Hello all, happy hump day!

I have columns for 30days past invoice date, 60days past invoice date, 90days etc.

The formula is set to record a date according to todays date vs invoice date and puts that date in the appropriate column (30-45-90-120). There is a running total for invoices until they are paid, but I am wondering what conditional formula I might use to sum the columns... so for example, there are 3 invoices which sit in the 45 day column... I want to know what the total of those invoices are.

Sorry if this is confusing.

 

[MartyS]

Excel 2010

	A	B	C	D	E	F
1	Inv Amt		30	45	90	120
2	100		06/05/1906		15/04/1962
3	100		07/02/1907	27/12/1964		05/12/2011
4	100		21/03/1952
5	200		13/01/2003			09/06/1932
6	200			27/06/1969
7	200		20/11/1918		07/07/1969	28/08/1957
8	300		24/07/1993
9	300
10	300			02/07/1978
11	400			24/03/1986		02/01/1961
12	500			24/03/1986		21/09/1920
13	600				18/03/1952	17/05/1961
14
15
16		TOTALS	1000	1500	900	2000

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C16 =SUMIF(C$2:C$13,">0",$A$2:$A$13) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Is this what you're looking for?

Copy C16 and paste across to F16