Dear xlstime
In file formula show #NUM! error.Pls see it.
On Fri, May 31, 2013 at 6:44 PM, xlstime wrote:
>
> Hi Amar,
>
> PFA or excel 2003
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Fri, May 31, 2013 at 4:32 PM, amar takale wrote:
>
>> Dear XLS
>> Can you give me this ama
Dear XLS
Can you give me this amazing formula in Excel 2003.I use Excel 2003
Regards
Amar
On Thu, May 30, 2013 at 2:10 PM, Chaya wrote:
> Thanks priti for your formula, it will be a new learning era for me with
> varities of formula knowledge.
>
>
>
>
> Regards,
> Chaya
>
> The excel learner :
Thanks priti for your formula, it will be a new learning era for me with
varities of formula knowledge.
Regards,
Chaya
The excel learner :-)
On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav wrote:
> Dear XLS,
>
> It is very useful formula and nice formula I was trying the same with
> su
Dear XLS,
It is very useful formula and nice formula I was trying the same with
sumproduct ...but it not happen...
first time i have seen sumifs formula with index and match formula.
Regards,
Prafull Jadhav
MIS executive.
On Thu, May 30, 2013 at 1:57 PM, Chaya wrote:
> Thank you so much D
try this
=SUMPRODUCT(N($A$2:$A$83=$T$8)*N($B$2:$B$83=$U$8)*N($C$2:$C$83=$X9)*N($D$2:$D$83=Y$8)*INDEX($A$2:$P$83,,MATCH($V$8,$A$1:$P$1,0)))
On Thu, May 30, 2013 at 1:57 PM, Chaya wrote:
> Thank you so much Dear Xls. I was amazed you have used sum function,
> Actually i thought of sum function is
Thank you so much Dear Xls. I was amazed you have used sum function,
Actually i thought of sum function is used in only in numerical values
calculation. today i came to know it is used in many calculation. thank you
for that.
Thanks to all.
Regards,
Chaya
The excel learner :-)
On Thu, M
use sumifs with index and match combination..please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:03 PM, Chaya wrote:
> Dear Experts,
>
> I was trying to find the values from Rows and coumns which match the
> criteria from the data validati
Dear Experts,
I was trying to find the values from Rows and coumns which match the
criteria from the data validation like wise in the attached file. please
suggest me the formulas, which formula might get used for finding the
answer. hope that i could able to elabroate by query correctly, pl