Results 1 to 5 of 5

Calculating Percentage based on Dynamic Cells

Threaded View

  1. #1
    Banned User!
    Join Date
    08-14-2008
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007 - Expertise Novice
    Posts
    69

    Calculating Percentage based on Dynamic Cells

    Hi Everyone,

    Need a small help

    I need to calculate the percentage based on self populating score. however I want excel/formula to ignore any cells which has "NA" in it so that it calculates the percentage based only on the cells having Numbers.

    Now these Cells which contain Numbers might or might not contain numbers based on the "IF" function which decides wether the cell will have numbers or will remain "blank" or have "NA"

    To understand better please have a look at the enclosed sample (that would explain my need better)

    Thanks In advance
    Attached Files Attached Files
    Last edited by dimitrz; 12-17-2008 at 04:45 AM.

Thread Information

Users Browsing this Thread

There are currently 5 users browsing this thread. (0 members and 5 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1