Results 1 to 18 of 18

Countif problem (with formule inside)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Countif problem (with formule inside)

    I have a short question where I am struggling with for a while:

    I have a formule with countifs:
    I want to count if:

    Count if the seperate values in column G minus K45 are bigger than 30.

    I tried a lot of things like the option below: (I know bit stupid option)
    =COUNTIF(ALL!$G:$G;"-k45"&">=30")

    Hope someone can help me!

    Thanks a lot
    Last edited by keis386; 07-22-2012 at 04:05 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 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