Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

2018-06-24 Thread amar takale
thanks anukar sirji.Great On Sun, Jun 24, 2018 at 1:51 AM, ankur wrote: > HI atul > > check this solution > > > > > > > *With Regards:* > > *CMA** Ankur Pandey* > *B.Com (H), C.M.A * > * Mob: :- +919532513513* > > > *P* Please don't print this e-mail unless you really need it. > > "This e-ma

Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

2018-06-23 Thread ankur
HI atul check this solution *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message may contain confidential, proprietary or legally privileged information intended solely for

Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

2018-04-28 Thread amar takale
Rabindra Sir,Thanks for reply. I got array formula below (Cell C17 paste) =SUM(IF(E4:E715=A17,IF(ISNUMBER(G4:G715),G4:G715))) Regards Amar On Sat, Apr 28, 2018 at 2:28 PM, Rabindra Thapa wrote: > #N/A Should be remove from column G > > *Regards,* > > > > *For quick responds click here for Mes

Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

2018-04-28 Thread Rabindra Thapa
#N/A Should be remove from column G *Regards,* *For quick responds click here for Message * On Sat, Apr 28, 2018 at 11:46 AM, amar takale wrote: > > -- > 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 foru

$$Excel-Macros$$ Exclude #N/A & Sumif excel formula

2018-04-28 Thread amar takale
-- 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 thread titles, like Please Help, Urgent, Need Help, F