SUM of Data based on a Condition & Running Macro. PLEASE HELP!

[jmcgillis14]

I have a very long list that I run a macro for. I need the total credit cards (Visa + Master Card + American Express) for that day. On top of that I am running a Macro and the date range is different every time. I think I need a formula that consolidates the "Date" Column so it doesn't repeat then I can come up with a rules based on that to pull out the credit cards and add them up? Let me know if there is any way you can help. Thank you! Below is three columns which is an example of the data. To the right is an example of what I am trying to accomplish.

[TABLE="width: 712"]
<tbody>[TR]
[TD]Account Name[/TD]
[TD] Amount[/TD]
[TD] Date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACH[/TD]
[TD="align: right"]$24.03[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Checks[/TD]
[TD="align: right"]$71.61[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD] TRYING TO ACCOMPLISH BELOW:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - Visa[/TD]
[TD="align: right"]$156.00[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD]Total Credits Credit Cards[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Credit Card - Master Card[/TD]
[TD="align: right"]$25.00[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD="align: right"]$181.00[/TD]
[TD="align: right"]8/17/2018[/TD]
[/TR]
[TR]
[TD]Late Fee Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD="align: right"]$233.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[/TR]
[TR]
[TD]Rental Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD][/TD]
[TD="align: right"]$671.23[/TD]
[TD="align: right"]8/23/2018[/TD]
[/TR]
[TR]
[TD]Cash[/TD]
[TD="align: right"]$289.22[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - American Express[/TD]
[TD="align: right"]$120.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - Visa[/TD]
[TD="align: right"]$113.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Administrative Fee Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Late Fee Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Airport Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Parking Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/20/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Parking Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/21/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rental Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/21/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - Visa[/TD]
[TD="align: right"]$413.00[/TD]
[TD="align: right"]8/22/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rental Revenue[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]8/22/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - American Express[/TD]
[TD="align: right"]$260.00[/TD]
[TD="align: right"]8/23/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - Master Card[/TD]
[TD="align: right"]$59.90[/TD]
[TD="align: right"]8/23/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Card - Visa[/TD]
[TD="align: right"]$351.33[/TD]
[TD="align: right"]8/23/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Book1
	A	B	C	D	E	F
1	Account Name	Amount	Date
2	ACH	$24.03	8/17/2018
3	Cash	$21.00	8/17/2018
4	Checks	$71.61	8/17/2018			4
5	Credit Card - Visa	$156.00	8/17/2018		Total Credits Credit Cards	Date
6	Credit Card - Master Card	$25.00	8/17/2018		$181.00	8/17/2018
7	Late Fee Revenue	$0.00	8/17/2018		$233.00	8/20/2018
8	Rental Revenue	$0.00	8/17/2018		$413.00	8/22/2018
9	Cash	$289.22	8/20/2018		$671.23	8/23/2018
10	Credit Card - American Express	$120.00	8/20/2018
11	Credit Card - Visa	$113.00	8/20/2018
12	Administrative Fee Revenue	$0.00	8/20/2018
13	Late Fee Revenue	$0.00	8/20/2018
14	Airport Revenue	$0.00	8/20/2018
15	Parking Revenue	$0.00	8/20/2018
16	Parking Revenue	$0.00	8/21/2018
17	Rental Revenue	$0.00	8/21/2018
18	Credit Card - Visa	$413.00	8/22/2018
19	Rental Revenue	$0.00	8/22/2018
20	Credit Card - American Express	$260.00	8/23/2018
21	Credit Card - Master Card	$59.90	8/23/2018
22	Credit Card - Visa	$351.33	8/23/2018
Sheet1

In F4 control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(ISNUMBER(SEARCH("credit card",$A$2:$A$22)),$C$2:$C$22),$C$2:$C$22),1))

In E6 just enter and copy down:

=IF($F6="","",SUMIFS($B$2:$B$22,$A$2:$A$22,"*credit card*",$C$2:$C$22,$F6))

In F6 control+shift+enter, not just enter, and copy down:

=IF(ROWS($1:1)>$F$4,"",MIN(IF(ISNUMBER(SEARCH("credit card",$A$2:$A$22)),IF(ISNA(MATCH($C$2:$C$22,$F$5:F5,0)),$C$2:$C$22))))