Look up a cell in column and add another

Closed
earhartc - Jul 14, 2009 at 04:39 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 15, 2009 at 06:05 AM
Hello,
I'm trying to look up an item in one column and see how many were sold from another column. The columns are side by side. There are 5 items sold in the first column, and trying to find out many total in the other. Or, like how many were sold on a Monday for an entire year.
It would look like this.
A B
Day Sold
Mon 110
Tues 50
Wed. 10
Thurs 20
Frid 30
Sat. 40
Sun 50
Mon 60
Tues 70
Wed. 80
Thanks for any help you can provide.

1 reply

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 160
Jul 15, 2009 at 06:05 AM
YOU CAN SIMPLE USE

=SUMIF(A3:A7,D3,"Frid",B7)
0