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.

Category	2014/01/01	2014/02/01	2014/03/01	2014/04/01
Misc	10.00	5.12	0.00	15.00
Car	10.00	0	15.00	15.00
Misc	5.00	15.00	20.25	9.99
Date:	2014/01/01
Misc	15
Car	10

<tbody>
</tbody>

 

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