Using SUM/IF and vlookup

[ctidmississippi]

I am not totally certain these are the formulas I need to be using, but I have a list of entries of days (which most days used numerous times), and sales per day. How can I get these totaled? A problem I have encountered is when I have used a SUMIF and include 11, it totals anything with those numbers in that order (211, 311, etc).
[TABLE="width: 500"]
<tbody>[TR]
[TD]11
[/TD]
[TD]490[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]501[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]202[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]311[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]399[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]403[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]217[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]107[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

A problem I have encountered is when I have used a SUMIF and include 11, it totals anything with those numbers in that order (211, 311, etc).

Can you post the exact formula you are trying?

 

[ctidmississippi]

Well, that's the thing. I have been through so many, I can't re-find it. I am extremely new to this, and no tutorials go over it, they only cover stuff with one such number in the A column

 

[ctidmississippi]

anyone?

 

[THDITRick]

If the 11, 12, 13 are in column A, and the sales per day are in column C:
=SUMIF(A1:A10, "11", C1:C10)
=SUMIF(A1:A10, "12", C1:C10)
=SUMIF(A1:A10, "13", C1:C10)

Just change the ranges to what you're using, as well as columns, and place the formulas where you want the totals.

 

[Aladin Akyurek]

Either...

[TABLE="class: grid, width: 320"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]day[/TD]
[TD="width: 64, bgcolor: transparent"]value[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]day[/TD]
[TD="width: 64, bgcolor: transparent"]total[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]11[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]490[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: #FFFFFF"]11[/TD]
[TD="bgcolor: transparent, align: right"]1504[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]11[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]501[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: #FFFFFF"]12[/TD]
[TD="bgcolor: transparent, align: right"]802[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]11[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]202[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: #FFFFFF"]13[/TD]
[TD="bgcolor: transparent, align: right"]823[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]11[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]311[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]12[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]399[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]12[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]403[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]13[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]400[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]13[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]217[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]13[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]99[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: #FFFFFF"]13[/TD]
[TD="width: 64, bgcolor: #FFFFFF"]107[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


In E2 enter and coy down:

=SUMIFS(B:B,A:A,$D2)

Or insert a PivotTable

[TABLE="class: grid, width: 240"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Sum of value[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]1504[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]802[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]823[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]3129[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]