Very Urgent Help needed Simple Formula Conditional SUM

[jamilm]

Dear Gurus,

please have a look at the worksheet i have uploaded

https://skydrive.live.com/redir?resid=D7C00A2BF29043E0!239


I wanted to get two results

A and B

I achevied getting result on A . but for B i failed to get result. I want to achive the result B which has one more condition explained in the worksheet and I wonder how to get result as my formula does not work. Or perhaps if you know any other better sultion formula through DSUM or SUMIFS or VBA code.

i would greatly appreciate your earleist feedback on my code.

i am sure it is simple, but my brain cannot get it.

thanks.

Sincerely
Jamil

 

[Vidar]

Hi Jamil

Try this formula for formula B:
=SUMPRODUCT(GL_Details!$Q$2:$Q$1749,--ISNUMBER(MATCH(GL_Details!$B$2:$B$1749,{2009\2010\2011},0)),1-ISNUMBER(MATCH(GL_Details!$C$2:$C$1749,{0\999\998},0)),--(LEFT(GL_Details!$J$2:$J$1749,2)="51"))

Vidar

 

[jamilm]

Hi Vidar,

many thanks. the part 2009\2010\2011 give me error and then i changed it to commas 2009,2010,2011 then it worked.

i was missing the part on the LEFT text formula.

thanks a mlllion.

i love you all , Mrexcel forum is the best forum is terms of quick reponse.

 

[Vidar]

You're welcome Jamil , and thank you for the reply.
I forgot to change the "\" back to commas.

Vidar

 

[jamilm]

thanks very much Vidar and those who are always so responsive. I already mentioned the fantastic support from MrExcel Forum but wanted to note it again. This type of support goes a million miles in terms of credibility of swift and accurate response.
i have been member with other excel support forum but mrexcel forum is the best, very fast response always. as we are talking minutes here not hourse or days like other forums.

i rate this thread five star.

cheers,
Jamil

You're welcome Jamil , and thank you for the reply.
I forgot to change the "\" back to commas.

Vidar