Hi,
I'm in a bit of a rut. If anyone can help me I'd greatly appreciate it.

I need Excel to find all order placed during the month of January, and then calculate the total. Column 'A' has the order date, and Column 'G' has the price. I need my function to gather all orders place in the month of January and then take the price from Column 'G' for all those orders and place them in a separate cell.

Does anyone have the slighest idea what I'm talking about, and how to do it? Thanks. :)

The Data>Subtotal capability may help you get what you need. But you need to do a couple of things first.


1) make sure each column has a column header

2) insert a column next to the date column you currently have, and copy the dates over to that new column. Put the header NewDate on the new column. Then highlight the new column and set the format to Custom mm/yyyy That will give you a column of dates that are displayed as the two-digit month and the four-digit year.

3) select a cell, any cell, in the new column

4) Select Data>Subtotals from the menu bar. If you are prompted about expanding the selection area, say "yes"

5) You should be looking at the Subtotal dialog box.

6) For the prompt "At each change in", select NewDate

7) ... "Use function", select Sum

8) ... "Add subtotal to" select the column that you want the monthly subtotal on.

9) Select OK, and you should see your subtotals.

10) check out the help info on Subtotals for more info.


(the above works in Excel '97)

Look at the SUMIF function. It should do what you want.