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
Inv Amt
TOTALS

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]120[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"]06/05/1906[/TD]

[TD="align: right"]15/04/1962[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"]07/02/1907[/TD]
[TD="align: right"]27/12/1964[/TD]

[TD="align: right"]05/12/2011[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"]21/03/1952[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"][/TD]
[TD="align: right"]13/01/2003[/TD]

[TD="align: right"]09/06/1932[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"][/TD]

[TD="align: right"]27/06/1969[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"][/TD]
[TD="align: right"]20/11/1918[/TD]

[TD="align: right"]07/07/1969[/TD]
[TD="align: right"]28/08/1957[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24/07/1993[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"][/TD]

[TD="align: right"]02/07/1978[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"][/TD]

[TD="align: right"]24/03/1986[/TD]

[TD="align: right"]02/01/1961[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"][/TD]

[TD="align: right"]24/03/1986[/TD]

[TD="align: right"]21/09/1920[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"][/TD]

[TD="align: right"]18/03/1952[/TD]
[TD="align: right"]17/05/1961[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]

[TD="align: right"]1000[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]2000[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C16[/TH]
[TD="align: left"]=SUMIF(C$2:C$13,">0",$A$2:$A$13)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "][/TH]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Is this what you're looking for?

Copy C16 and paste across to F16