Need formula help! If/Sum/SumIf.

[skidragon02]

Hello Everyone,

I am trying to create a formula that gives me the following: "Where this date appears in column D, sum the values within columns E-G of the same row" (rough example below). How would I do this?

D E F G
2/7/2013 4 3 7
7/4/2013 7 2 1
7/4/2013 6 9 8

Since 7+2+1+6+9+8=33, my desired output would be "33".


Thanks in advance!

 

[json]

ever try a pivotTable? (assuming E:G has actual headers/titles/labels)

 

[bobhc]

Good day skidragon02
A table would do it

 

[skidragon02]

I have. I didn't even think about that and now I feel ridiculous...but it did the trick. Thanks!