excel sheet king

136°
Deal Brigadier
homedimer

excel sheet king pls help me

i hv to total the debit and credit both enteries

now problem is both are mixed..

like cr-

dr
cr
cr
dr
dr
dr

pls help

15 Comments  |  
10 Dimers
  • Sort By
Deal Lieutenant Deal Lieutenant
Link Copied

Use sumif

Deal Brigadier Deal Brigadier
Link Copied

any way to like this
make

cr cr
dr cr
cr cr
dr cr
Cr cr
cr dr
cr dr
dr dr
dr dr

credit enteries first then dr??

View 9 more replies
Deal Subedar Deal Subedar
Link Copied

offtopic: there was a topic created by you once (in which @panchabhut quipped about seeing your posts after loooong. he seemingly missed to check your complete posts https://www.desidime.com/users/53930/posts?arch... including the archived ones)

did you got coerced into asking for it to be deleted (archived)
or
was it done by some content editor on their own?

just curious, nothing else.

Tech Guru Tech Guru
Link Copied

I’m not sure if it is suggested earlier.

Here is a way. Go to Data Tab, Hit on Filter option. You can choose the required selections from the drop down

Deal Cadet Deal Cadet
Link Copied

Use filter using contains Cr …. then use subtotal function to add only Cr part …. do same for Dr

another way is : use substring function to identify Cr or Dr & then concatenate the value in new column & sort it

replyuser
Click here to reply
Reply