Hi Deepak,
you also try this one
=SUMIF($A$2:$A$9,"Snickers ",B2:B9)+SUMIF($C$2:$C$10,"Potato",D2:D10)
On Wed, Jul 17, 2013 at 7:46 PM, ashish koul wrote:
> =SUMPRODUCT(($A$2:$A$9="Snickers
> ")*($B$2:$B$9)+($C$2:$C$9="Potato")*($D$2:$D$9))
>
> see if it helps
>
>
>
>
> On Wed, Jul 17, 2013
=SUMPRODUCT(($A$2:$A$9="Snickers
")*($B$2:$B$9)+($C$2:$C$9="Potato")*($D$2:$D$9))
see if it helps
On Wed, Jul 17, 2013 at 7:33 PM, Deepak Singh wrote:
>
>
> Hi all,
>
> I want total Calories of Snickers and Potato from below data ..Output is
> 1150, please solve..
>
>
> *ColumnA ColumnB
Hi all,
I want total Calories of Snickers and Potato from below data ..Output is
1150, please solve..
*ColumnA ColumnB Column C Column D*
Candy Calories Fruits & Vegetables Calories Snickers 350 Tomato 10
Twix 370 Potato 40 Skittles 450 Tomato 30 Snickers 35
