software

Using a spreadsheet with the following format:
ABC
1JEFFMONDAY $5.00
2LISAMONDAY $10.00
3LISAMONDAY $5.00
3JEFFTUESDAY $15.00

I need a formula in column E and F to calculate how much each person sold on
a certain day. If this is true, and this is true, sum this....

DEF
MONDAYTUESDAY
1JEFF $5.00 $15.00
2LISA $15.00 $-

THANK YOU!!!
TMF=SUMPRODUCT(--($A$1:$A$4=$D2),--($B$1:$B$4=E$1),$C$1:$C$4)

Place this formula in E2 and copy it across and dow. I used a table like
this (notice it includes the day names in row 1).

ABCDEF
1JEFFMONDAY$5.00MONDAYTUESDAY
2LISAMONDAY$10.00JEFF $5.00 $15.00
3LISAMONDAY$5.00LISA $15.00 $-
3JEFFTUESDAY$15.00You could also use something like this if you don't want the header row.

=SUMPRODUCT(--($A$1:$A$4=$D2),--($B$1:$B$4=quot;MONDAYquot;),$C$1:$C$4)
goes in E1

=SUMPRODUCT(--($A$1:$A$4=$D2),--($B$1:$B$4=quot;TUESDAYquot;),$C$1:$C$4)
goes in E2

copy down as needed.

Here is the table example.

ABCDEF
1JEFFMONDAY$5.00JEFF$5.00$15.00
2LISAMONDAY$10.00LISA$15.00$0.00
3LISAMONDAY$5.00
4JEFFTUESDAY$15.00PS - One thing to note is B2 contains an uneeded blank space at the end that
might cause you to have an error. quot;MONDAYquot; does not equal quot;MONDAY quot;

gt;
quot;TMF in MNquot; wrote:

gt; Using a spreadsheet with the following format:
gt; ABC
gt; 1JEFFMONDAY $5.00
gt; 2LISAMONDAY $10.00
gt; 3LISAMONDAY $5.00
gt; 3JEFFTUESDAY $15.00
gt;
gt; I need a formula in column E and F to calculate how much each person sold on
gt; a certain day. If this is true, and this is true, sum this....
gt;
gt; DEF
gt; MONDAYTUESDAY
gt; 1JEFF $5.00 $15.00
gt; 2LISA $15.00 $-
gt;
gt; THANK YOU!!!
gt; TMF
gt;

=SUMPRODUCT(--($A$1:$A$4 = $D2),--($B$1:$B$4 = E$1),($C$1:$C$4))
copied accross and down.

--
Kevin Vaughnquot;TMF in MNquot; wrote:

gt; Using a spreadsheet with the following format:
gt; ABC
gt; 1JEFFMONDAY $5.00
gt; 2LISAMONDAY $10.00
gt; 3LISAMONDAY $5.00
gt; 3JEFFTUESDAY $15.00
gt;
gt; I need a formula in column E and F to calculate how much each person sold on
gt; a certain day. If this is true, and this is true, sum this....
gt;
gt; DEF
gt; MONDAYTUESDAY
gt; 1JEFF $5.00 $15.00
gt; 2LISA $15.00 $-
gt;
gt; THANK YOU!!!
gt; TMF
gt;