Subtotal Question

[fgmoon353]

First time post, I've been searching all over the web and haven't found squat...

I'm trying to subtotal shipments by date and cost. I can do that. I also need to know the subtotal for the first 3 shipments per day. For Example. On Monday we had 6 shipments, how much were the first 3 of the day, for every day, for like the last 3 months. So it's not like I can do this manually.


Like I said, so far, I've got my spreadsheet subtotaled for date, but that's as far as I've gotten.

Thanks in advance.

 

[barry houdini]

Hello fgmoon353, welcome to MrExcel

If you have shipment date in column A, shipment time in column B and cost in column C then try this formula in D2 down to get the instance number in each day

=COUNTIFS(A:A,A2,B:B,"<"&B2)+1

now you can sum for the first 3 instances with

=SUMIF(D:D,"<=3",C:C)

use SUMIFS with more conditions if you only want that for a specific date period

[COUNTIFS and SUMIFS require Excel 2007 or later]

 

[fgmoon353]

Thanks for the Countifs function introduction, that worked well!

When I put in the sumif function (I'm guessing I'm supposed to put it in E2) I get a grand total of ALL of the first three shipments for everyday in my spreadsheet. I need the sum of the first three per day itemized. How can I do that?

Thanks again!