Pull out multiple values from table

[bull699]

So I've got a table that the user submits data to, which includes, amongst other things, a date/time and net profit for each entry. When an entry is submitted, the first column gets a date and time stamp (vba "now"). I have a stats box where I want to show 'total profit for past 24 hours/7 days/28 days'. I need a formula to recognise these date/times periods and to sum together the total net profits, which sit 6 rows across.

Many Thanks

[ChemistB]

Assuming you mean 6 columns across and
Without a spreadsheet to look at (hint: Go Advanced>Manage Attachments), how about

=SUMIF($A$2:$A$100, ">=" & NOW()-1, $D$2:$I100)
=SUMIF($A$2:$A$100, ">=" & NOW()-7, $D$2:$I100)
=SUMIF($A$2:$A$100, ">=" & NOW()-28, $D$2:$I100)

[bull699]

Genius! You get extra points for deciphering my poor description

Thank you very much