Sum Column

[debug]

Hi Guys

I want to lookup a date in a row then sum all items based on a value in the column.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]2014/01/01[/TD]
[TD]2014/02/01[/TD]
[TD]2014/03/01[/TD]
[TD]2014/04/01[/TD]
[/TR]
[TR]
[TD]Misc[/TD]
[TD]10.00[/TD]
[TD]5.12[/TD]
[TD]0.00[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]10.00[/TD]
[TD]0[/TD]
[TD]15.00[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]Misc[/TD]
[TD]5.00[/TD]
[TD]15.00[/TD]
[TD]20.25[/TD]
[TD]9.99[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date:[/TD]
[TD]2014/01/01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Misc[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Maybe you can adapt this to your actual set-up:

Excel Workbook
	A	B	C	D	E
2	Category	01/01/2014	01/02/2014	01/03/2014	01/04/2014
3	Misc	10	5.12	0	15
4	Car	10	0	15	15
5	Misc	5	15	20.25	9.99
6
7	Date:	01/01/2014
8	Misc	15
9	Car	10
Sheet1

 

[Ron Coderre]

With your posted example in A1:E8

This regular formula returns the sum of data cells where the date equals A6 and the Category matches the Col_A value

B7: =SUMPRODUCT(($A$2:$A$4=A7)*($B$1:$E$1=$A$6)*$B$2:$E$4)

Is that something you can work with?

 

[debug]

Thx works perfectly...