summing up value based on another column criteria

No, Sir, Actully i have huge data set around with 80,000+ rows and 58 columns it was just a part of vba codings, i just posted a sample based with exact columns i have to append this codings into my actual data set of codes. hope you got it sir. thankyou

it's become a challenge for me, because we have match two columns criteria e.g. ColumnC & ColumnD and summingup ColumnO and resulting would come in ColumnN which also based on ColumnC & ColumnD criteria. As i am an intermediate student of VBA so i have basic knowledge, but still i think we can use here Lbound and Ubound codings, please help me out !!!

as i told in thread sir, that we have huge data set almost 80,000+ rows and 58 columns we have already vba coded file we have to just figure out this problem with coding if you will suggesting me any code than i will simply add that code in my actual huge data set coding file. so it will run from start to end. above query is just a part of that vba coded file. i even can't attach whole file it's almost 64 mb excel file would you like to do whole vba activity for us in free of cost ??? and i guess answer is NO, hence i just posted a illustration samples just for understanding purpose so i could get any code for it.

Thankyou

Could you attach your sample workbook?
Please read the yellow banner at the top of the page on how to attach your sample workbook.
Please include the result as wanted.

i think have attached the sample file

Dear Akuini

I have attched the sample file

Please go through it...and thankyou so much for helping me out !!

Why are you posting this question when you said it was solved three days ago on another forum?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

when i am trying to attach link it's not posting my replay.

Dear Moderator please de-activate my account from here. i have already member of another board. i extremely apologize.

Dear Moderator,

Thankyou so much for co-operating with me, i got the answer from another board and also he asked me to read why cross posting is not allowing on board, i totally understand and respect to all coder & developer, as this is my first time where i am posting question on some board and finding the answer, hence i am not much aware of certain rules, and truth is also i have not read it, but now i got the solution of query, please help me or suggest how can i mark query has been resolved.

Thankyou and i am on learning stage so i promise i will learn all boards rules steadly.

okay got it.

https://www.mrexcel.com/board/thread...3#post-5607574

i tried before but our forum was not accepting my replay.

i must say thankyou to you...

thankyou for co-operating and guidance to me.

okay sure.

your welcome.

Hii AliGW moderator, Good morning, Hope you doing well,

Below is my new query can you please help me out, it's basically about substracting in merge cells,

I have merged cells value in ColumnK & ColumnO what we need to do is substracting ColumnO-ColumnK and merged result should be in ColumnP,

ColumnK ColumnO
80 100


50 90


60 100

so merged result would in ColumnP accordingly 20,40,40,

below is attached link of another forum, but as my sir said that he is not working on merged cells, you can read the comment, please help me out for finding above solution in vba codes,

https://www.mrexcel.com/board/thread...3#post-5608010

Thankyou

ok sure