Use this formula with Ctrl+Shift+enter
=SUM(IF($D$2:$AB$2=AC$2,$D$3:$AB$3))
On Thu, Feb 28, 2013 at 10:25 AM, Anoop K Sharma wrote:
> Use attached one. This'll take care of text values also.
>
>
> On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote:
>
>> But if some in some place text exists t
Use attached one. This'll take care of text values also.
On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote:
> But if some in some place text exists then what to do
>
> Regards,
> Deepak
>
>
> On Wed, Feb 27, 2013 at 8:47 PM, Maries wrote:
>
>> Hi,
>>
>> Try it,
>>
>> =SUMIF($D$2:$AB$2,AC2,D$
Hi,
Try it,
=SUMIF($D$2:$AB$2,AC2,D$3:AB$3)
On Wed, Feb 27, 2013 at 6:26 PM, Deepak Rawat wrote:
> Sorry attached wrong one
> now attached the correct one.
>
> Regards,
> Deepak
>
>
> On Wed, Feb 27, 2013 at 5:41 PM, David Grugeon wrote:
>
>> We need more information. What do you want the sum
We need more information. What do you want the sum of? There does not
seem to be anything in the worksheet provided that you could possibly want
to add up.
On Wednesday, 27 February 2013, Deepak Rawat wrote:
> Hi,
>
> need formula for sum in attach
>
> Regards,
> Deepak
>
> --
> Are you =EXP(E:
Hi,
need formula for sum in attach
Regards,
Deepak
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor th
