Formula help [SOLVED]

[aparvez007]

Hi Ninja's,

I please check uploaded file I want formula for sum of target.
I have area and month drop down in J3 & D3 respectively.
I put the desire output in cell p10 & p11.

Regards,
pAvi

 

[Mike H..]

Hi Ninja's,

I please check uploaded file I want formula for sum of target.
I have area and month drop down in J3 & D3 respectively.
I put the desire output in cell p10 & p11.

Regards,
pAvi

See the attached workbook

 

[Haseeb A]

Hello Pavi,

Since you already have helper row in Target!B1:BZ1, you could use simple SUMIF,

=SUMIF(Target!A:A,O10,INDEX(Target!B:BZ,0,MATCH(A$1,Target!B$1:BZ$1,0)))

 

[aparvez007]

Thanks Mike and Haseeb both Formula working.

Regards,
pAvi