+ Reply to Thread
Results 1 to 3 of 3

Calcualting Only Visable (Filtered) Data?

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Question Calcualting Only Visable (Filtered) Data?

    Hello,
    I wanted to know if it's possible to create formulas that only calculate visible data using the filler tool in Excel. I wanted to see if this was possible before posting a question about the actual formulas I need.


    Thank you for any and all help with this, it's greatly appreciated.
    Last edited by artiststevens; 12-24-2016 at 03:07 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,054

    Re: Calcualting Only Visable (Filtered) Data?

    In short... Yes.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Calcualting Only Visable (Filtered) Data?

    Thank you Glenn for the quick response and help with this

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMPRODUCT on visable(filtered)cells
    By RussHaight in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2016, 02:53 PM
  2. [SOLVED] Select next visable row - when filtered
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2016, 11:55 AM
  3. [SOLVED] SUMIF calcualting zero but don't want zero to show
    By szp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-07-2013, 05:07 PM
  4. Replies: 4
    Last Post: 09-04-2012, 06:09 AM
  5. Formula for calcualting qty at given std size.
    By gene-stevo in forum Excel General
    Replies: 3
    Last Post: 11-02-2007, 07:46 AM
  6. problem with calcualting
    By eggandbacon in forum Excel General
    Replies: 2
    Last Post: 03-21-2005, 02:23 PM
  7. [SOLVED] Pivot table. Calcualting % from subtotals.
    By Ray D in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2005, 09:06 AM

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