Small Excel Question Not Worth Its Own Thread

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Nippashish: Nov 2, 2005; Let me see you dance!

I have a table of data which looks like this:

code:

Date       Item    Cost
20-Aug-10  Hats    $20.00
20-Aug-10  Bats    $10.00
20-Aug-10  Cars    $55.00
21-Aug-10  Coats   $13.00
21-Aug-10  Boats   $17.00
22-Aug-10  Stoats  $31.00
22-Aug-10  Goats   $21.00

... and so on. I would like to be able to sum up daily (and weekly/monthly/yearly/etc.) totals from this data, so for daily totals I would end up with:

code:

Date       Total
20-Aug-10  $85.00
21-Aug-10  $30.00
22-Aug-10  $52.00

There can be any number of transactions per day (and some days might be missing). This seems like it must be a common problem, but I haven't been able to find anything via google.

Edit: I've found the "subtotals" tool which can do the reduction I want, but it puts the results inline with the original data which is really not suitable.

Nippashish fucked around with this message at 00:12 on Aug 29, 2010

# ¿ Aug 28, 2010 23:26

Adbot: ADBOT LOVES YOU

# ¿ May 6, 2024 02:53

Nippashish: Nov 2, 2005; Let me see you dance!

I got it working with SUMIF. I actually tried that earlier but like an idiot I was passing the wrong arguments to SUMIF.

# ¿ Aug 29, 2010 02:17

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread