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).

11	490
11	501
11	202
11	311
12	399
12	403
13	400
13	217
13	99
13	107

<tbody>
</tbody>

 

[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...

day	value		day	total
11	490		11	1504
11	501		12	802
11	202		13	823
11	311
12	399
12	403
13	400
13	217
13	99
13	107

<tbody>
</tbody>

In E2 enter and coy down:

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

Or insert a PivotTable

Row Labels	Sum of value
11	1504
12	802
13	823
Grand Total	3129

<colgroup><col><col><col></colgroup><tbody>
</tbody>