Sum Column

debug

New Member
Joined
Nov 4, 2010
Messages
29
Hi Guys

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


Category2014/01/012014/02/012014/03/012014/04/01
Misc10.005.120.0015.00
Car10.00015.0015.00
Misc5.0015.0020.259.99
Date:2014/01/01
Misc15
Car10

<tbody>
</tbody>
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Maybe you can adapt this to your actual set-up:

Excel Workbook
ABCDE
2Category01/01/201401/02/201401/03/201401/04/2014
3Misc105.12015
4Car1001515
5Misc51520.259.99
6
7Date:01/01/2014
8Misc15
9Car10
Sheet1
 
Upvote 0
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
Code:
B7: =SUMPRODUCT(($A$2:$A$4=A7)*($B$1:$E$1=$A$6)*$B$2:$E$4)

Is that something you can work with?
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top