Results 1 to 7 of 7

Thread: ms ofice expert..need ,help me

  1. #1
    thecute is offline Senior Member+
    Last Online
    28th June 2015 @ 01:00 PM
    Join Date
    27 Jul 2008
    Age
    34
    Posts
    292
    Threads
    73
    Credits
    0
    Thanked: 1

    Question ms ofice expert..need ,help me

    kia kisi ko ms ofice 2007 ma "sum" ka formula ata hay jo ek line skip kar k baki line ko add kar k un ka sum nekale ...? for example 1,2,3,4,5,6..line hay mane 2,3,6 ko add kar k sum nekalna hay ..kia ya mumkin hay ....?plz help me

  2. #2
    rknaeem's Avatar
    rknaeem is offline Senior Member+
    Last Online
    5th February 2016 @ 08:33 PM
    Join Date
    02 Jul 2009
    Location
    اسلام آباد
    Age
    29
    Gender
    Male
    Posts
    935
    Threads
    40
    Credits
    795
    Thanked
    51

    Default

    sory nai samajh aya

  3. #3
    thecute is offline Senior Member+
    Last Online
    28th June 2015 @ 01:00 PM
    Join Date
    27 Jul 2008
    Age
    34
    Posts
    292
    Threads
    73
    Credits
    0
    Thanked: 1

    Default

    yar mera matlab hay k mera pas file hay us ma 170 rows hay jis ko mane add karna hay colume D ma ...ma ya chahta hu k ma in sab k sum lu...like this ..=sum(D1170)...is se ya sab row ko add kar leta hay colume D ma ..per ma chahta hu k wo ek row chor k add kare ...mean ...2,4,6,7,8,10,12,14,16.....etc row add kare ....or 1,3,5,7,9,11,13,,,,..... ya wali add na kare ...tp us k liye koi fomula hay kia ??????

  4. #4
    Kashif Mehmood1's Avatar
    Kashif Mehmood1 is offline Advance Member
    Last Online
    23rd January 2022 @ 06:51 PM
    Join Date
    30 May 2009
    Location
    Rawalpindi
    Age
    33
    Gender
    Male
    Posts
    1,392
    Threads
    49
    Credits
    1,198
    Thanked
    58

    Default

    aap aise likhain formula bar main
    =sum(A2+A4+A6)
    Last edited by Kashif Mehmood1; 18th February 2010 at 10:28 AM.

  5. #5
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Thanked
    30

    Default

    Quote Kashif Mehmood1 said: View Post
    aap aise likhain foemula bar main
    =sum(A2+A4+A6)
    yes u r right

  6. #6
    raz24726's Avatar
    raz24726 is offline Senior Member+
    Last Online
    9th October 2019 @ 07:51 PM
    Join Date
    16 Dec 2009
    Location
    Agr Milu To Muj
    Gender
    Male
    Posts
    5,502
    Threads
    79
    Credits
    969
    Thanked
    432

    Default

    Dear Ye Dekhe agar aap ko line skip karke sum kana he to ye formula acha b or fast b lagta he =sum karne ki zrurt b nai padegi only + press karo phir range pe arrow k madad se jao phir + press karo phir 2nd range pr jao ese e age b karna he

    ye Dekhe
    Attached Images Attached Images  

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    try any where with the following formula .
    I assume D1170 houses your data.

    Code:
    =SUMPRODUCT(--(MOD(ROW($D$1:$D$170),2)=0),$D$1:$D$170)
    agar answer wrong mele tu jahan se aap ka data shoro hota ha us cell ka address bata dain. Ya formula m khod adjust kar lain.

    hope this will help

    regards

Similar Threads

  1. me apny ofice k liye ek program bnana chata ho help me.
    By amjab bozdar in forum Ask an Expert
    Replies: 22
    Last Post: 17th October 2014, 11:03 PM
  2. Solved Me Apne Ofice Me CCTV cemra Kis trha Instal karon.Kia me khud kr skta hn
    By blank in forum Solved Problems (IT)
    Replies: 7
    Last Post: 8th September 2012, 02:49 PM
  3. urgent help..befor light gone...:( ms ofice 2007
    By thecute in forum Ask an Expert
    Replies: 2
    Last Post: 26th January 2010, 05:49 PM
  4. Ms Ofice k baray main thori mushkil help
    By Inam Anajum in forum Ask an Expert
    Replies: 4
    Last Post: 15th August 2009, 06:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •