IF statement to check for value in range and if true include adjacent value in SUM

[WikeMo1]

Hello,

This seems like it would be easy, but maybe it's not.

I am trying to construct a daily tally list for task completion in one sheet that would then show a running total in another sheet as a "dashboard."


Here is a type of example.
https://1drv.ms/x/s!Avza4YgA-BnDjCcyut2cvLSv_6ag

In this example I would want the cells in the sheet "List and Totals" to test for wherever the value in the list in column A is present in column B of the sheet "Tally."

For whatever value is present in column B of the sheet "Tally," I would like to then have it sum the corresponding info into a running total in the proper row in "Lists and Totals."

For example, at this point I would want it to show the totals that are currently manually placed in "List and Totals."

Thanks in advance for any help!

 

[AhoyNC]

See if this works for you.
Copy formula down and across.

Excel Workbook
	A	B	C	D	E	F	G
1		Item 1	Item 2	Item 3	Item 4	Item 5	Item 6
2	Option 1	0	0	0	0	0	0
3	Option 2	6	5	4	5	6	6
4	Option 3	0	0	0	0	0	0
5	Option 4	10	10	0	0	0	0
6	Option 5	0	0	0	0	0	0
7	Option 6	0	0	0	0	0	0
List and Totals

Excel Workbook
	A	B	C	D	E	F	G	H
1	Date	Option	Item 1	Item 2	Item 3	Item 4	Item 5	Item 6
2	13-Sep-19	Option 2	3	2	4	5	6	6
3	14-Sep-19	Option 4	10	10
4	15-Sep-19	Option 2	3	3
5	16-Sep-19
6	17-Sep-19
7	18-Sep-19
8	19-Sep-19
9	20-Sep-19
10	21-Sep-19
11	22-Sep-19
12	23-Sep-19
Tally

 

[WikeMo1]

See if this works for you.
Copy formula down and across.

Ok thanks! I will try it out this morning!

 

[WikeMo1]

Tried and seems to be working great!
Thanks!

Now, I can't say I understand what it's doing, because I don't see how this is working according to my understanding of the "official explanation" of what SUMPRODUCT is supposed to be doing. But that's on me

 

[AhoyNC]

You're welcome.

The first two sections of the formula return an array of TRUE or FALSE.
This part ($A3=Tally!$B$2:$B$12) returns
[TABLE="width: 480"]
<colgroup><col width="480"></colgroup><tbody>[TR]
[TD="width: 480"]{TRUE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}
Excel will change the TRUE, FALSE to 1 and 0 when you do a math operation, so this part
[TABLE="width: 452"]
<colgroup><col width="452"></colgroup><tbody>[TR]
[TD="width: 452"]($A3=Tally!$B$2:$B$12)*(B$1=Tally!$C$1:$H$1)*(Tally!$C$2:$H$12) returns this array to SUMPRODUCT
[TABLE="width: 763"]
<colgroup><col width="763"></colgroup><tbody>[TR]
[TD="width: 763"]{3,0,0,0,0,0;0,0,0,0,0,0;3,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0;0,0,0,0,0,0} which returns the value of 6 for cell B3 in the example above.
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[WikeMo1]

Ah! Great!
Thanks again!