Counting in specific events in a date range

I'm trying to count the number of chargebacks that were received in 1 month but were for different months.

An example: I received 29 chargebacks in July, and 8 were for May, 9 were for April, 10 for June, and 2 for July trx.

I've been trying to use countif but am falling short of accomplishing this. I've been able to get the total chargebacks in the timeframe, but further breaking it down has been a pain.

For # of chargebacks received in a given month, I've used:
=COUNTIF(Total!$G$2:$G$4000,">5/31/2008")-COUNTIF(Total!$G$2:$G$4000,">6/30/2008")

For # of chargebacks FOR a given month, I've used:
=COUNTIF(Total!$F$2:$F$4000,">5/31/2008")-COUNTIF(Total!$F$2:$F$4000,">6/30/2008")

Column F is the transaction date, and date of notification for chargeback is G.

Any assistance folks can lend in this is MUCH appreciated. I have a preso to the board tomorrow and could REALLY use this data.

Sumproduct should help

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Can you post a sample file with expected results



VBA Noob

Does this help

In J3 try

=COUNTA(G:G)-1

In K3 and drag across

=SUMPRODUCT(--(TEXT($F$2:$F$30,"MMM")=TEXT(K2,"MMM")))

VBA Noob

Ah, one point of clarity to add - my spreadsheet has multiple months on it. While I only added July in the example, I have previous months data intermingled, which is what really makes this a pain.

Would a dynamic pivot group by month be a better option then

Dynamic Range
http://www.contextures.com/xlPivot01.html

Grouping by month
http://www.contextures.com/xlPivot07.html

If there is a problem grouping take a look at this link
http://www.contextures.com/xlPivot07.html#Problems

Pivot Table videos
http://video.about.com/spreadsheets/...vot-Tables.htm
http://www.datapigtechnologies.com/ExcelMain.htm

VBA Noob