Summary Different day expense

**top1** · 02-04-2010, 09:03 PM

hi,

I am trying to summary my differentday food data. i want to add total in SUmmary table. Thanks for your help.

TOP

**Palmetto** · 02-04-2010, 09:47 PM

I recommend you use a correct data structure as shown in the attached, then this formula

=SUMIF($M$3:$M$14,"*"&A10&"*",$N$3:$N$14)

**top1** · 02-04-2010, 10:04 PM

Originally Posted by Palmetto

I recommend you use a correct data structure as shown in the attached, then this formula

=SUMIF($M$3:$M$14,"*"&A10&"*",$N$3:$N$14)

Dear Palmetto,

Thanks for successfull help in solving my proble.

I am just wondring is there any easy way to do this without restructure the data.

THANKS

**khamilton** · 02-04-2010, 10:06 PM

per your example in B10 and copy down-->
=SUMIF($A$3:$A$6,"*"&A10&"*",$B$3:$B$6)+SUMIF($D$3:$D$6,"*"&A10&"*",$E$3:$E$6)+SUMIF($G$3:$G$6,"*"&A10&"*",$H$3:$H$6)

**Palmetto** · 02-04-2010, 10:29 PM

I am just wondring is there any easy way to do this without restructure the data.

Yes. As khamilton shows. However, my suggestion was intended to illustrate the correct way to structure data using a classic database style structure.

Your approach, as shown by khamilton, requires a longer, more complex formula and will necessitate much more maintenance to adjust for additional ranges of data.

**top1** · 02-04-2010, 11:02 PM

Thanks Khamilton and Palmetto.
Urs formula helped me to solve my problem. I really appreciate you help.

**Palmetto** · 02-04-2010, 11:07 PM

Glad to help.

Please mark your thread as solved by going to YOUR first post and clicking on Thread Tools, then Go Advanced and choose the [solved] prefix.

You can provide feedback or show appreciate to those who contributed a helpful response. See my signature for how to go about it.