Results 1 to 2 of 2

Thread: count blank cell in different criteria ???

  1. 18th May 2012, 12:59 PM #1
    naeem4raj's Avatar
    naeem4raj
    naeem4raj is offline Senior Member+
    Last Online
    7th February 2017 @ 11:59 AM
    Join Date
    20 Jan 2008
    Location
    Apke Dil Main
    Posts
    415
    Threads
    52
    Credits
    870
    Thanked
    6

    Default count blank cell in different criteria ???

    salam....
    mera ek simple sa question hai ...plz help me
    men ek sheet mn different jagon pe blank cell cont karna chahta hn..
    =countif(A1:A10,"")
    yeh to just A1 se A10 tk count karyga ...but mn chahta hn k sath c1:c5 & G34:G67 mn b count karon...
    like
    =countif(A1:10,B1:B10,"") par esa karny pe wo show nai kar raha..
    plz help me...mn wait kar raha hn...


    If We Both Exchange 1$,We Both Have 1$ Each


    But If We Exchange 1 Good Thought, We Both Have 2 Good Thoughts.

    N a e e m A w a n

    Email address Not allowed.(iTD Team)
    Reply With Quote Reply With Quote
  2. 18th May 2012, 08:57 PM #2
    *Noor-ul-Ain*'s Avatar
    *Noor-ul-Ain*
    *Noor-ul-Ain* is offline Senior Member+
    Last Online
    2nd August 2015 @ 06:06 PM
    Join Date
    21 Apr 2012
    Location
    Pakistan
    Age
    25
    Gender
    Female
    Posts
    3,120
    Threads
    79
    Credits
    900
    Thanked
    321

    Default

    =CountIf(A1:B10,"")
    ye formula use karein. q k jab ap aik comma k bad b1:b10 likhein gay tu excel es ko range k tor pe nahi ly ga. bulkay criteria k tor pe ly ga aur formula ghalat ho jaye ga.
    Reply With Quote Reply With Quote

Similar Threads

  1. SUM cell based on their interior color(Have fun with excel)
    By syar in forum General Discussion
    Replies: 22
    Last Post: 3rd June 2013, 05:56 PM
  2. Connect To Internet Using Your Cell Phone
    By IT_DOCTOR in forum General Mobile Discussion
    Replies: 19
    Last Post: 4th March 2010, 10:39 PM
  3. Cell Phone Cloning
    By jawadpk in forum General Mobile Discussion
    Replies: 8
    Last Post: 28th January 2010, 05:38 PM
  4. Exel short key
    By ttohid in forum General Discussion
    Replies: 8
    Last Post: 26th December 2009, 11:23 AM
  5. Extra tools within your cell phone
    By Muslim Sister* in forum General Mobile Discussion
    Replies: 10
    Last Post: 20th March 2009, 08:00 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
  •  

Forum Rules