software

I have a portion of a file that has the date, sale and card type. Here
is what it looks like:

A B C D
1/3/05 $10 VISA
1/3/05 $20 MCARD
1/3/05 $30 MCARD
1/3/05 $10 AMEX 1/3/05
1/4/05 $50 VISA 1/4/05
1/5/05 $30 VISA
1/5/05 $20 AMEX 1/5/05

I created column D which will display a single date at the end of the
day when there are multiple sales. What I need to do is get daily
totals for the VISA and MCARD together, and keep the total for AMEX
separate. The number of transactions on any day can range from 1 to
20. Ideally I would like the data to the right.

Any help would be appreciated.
Thanks,
Phillycheese--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: www.excelforum.com/member.php...oamp;userid=24196
View this thread: www.excelforum.com/showthread...hreadid=498445A.

=SUMPRODUCT(--($A$2:$A$8=E2),$B$2:$B$8,--ISNUMBER(MATCH($C$2:$C$8,{quot;MCARDquot;,quot;VISAquot;},0)))

where E2 houses a criterion date.

B.

=SUMPRODUCT(--($A$2:$A$8=E2),$B$2:$B$8,--($C$2:$C$8=quot;AMEXquot;))

Phillycheese5 wrote:
gt; I have a portion of a file that has the date, sale and card type. Here
gt; is what it looks like:
gt;
gt; A B C D
gt; 1/3/05 $10 VISA
gt; 1/3/05 $20 MCARD
gt; 1/3/05 $30 MCARD
gt; 1/3/05 $10 AMEX 1/3/05
gt; 1/4/05 $50 VISA 1/4/05
gt; 1/5/05 $30 VISA
gt; 1/5/05 $20 AMEX 1/5/05
gt;
gt; I created column D which will display a single date at the end of the
gt; day when there are multiple sales. What I need to do is get daily
gt; totals for the VISA and MCARD together, and keep the total for AMEX
gt; separate. The number of transactions on any day can range from 1 to
gt; 20. Ideally I would like the data to the right.
gt;
gt; Any help would be appreciated.
gt; Thanks,
gt; Phillycheese
gt;
gt;


Works perfectly, thanks!--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: www.excelforum.com/member.php...oamp;userid=24196
View this thread: www.excelforum.com/showthread...hreadid=498445