+ Reply to Thread
Results 1 to 2 of 2

frequency or countif , comparing cells in 2 ranges

  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    52

    frequency or countif , comparing cells in 2 ranges

    Hi,
    I have a sheet with three columns: "Store name", "Expected income" and "Actual income".
    Each store has its own actual and expected incomes.

    I want a cell to tell me how many stores in total achieved a lower than expected income.

    I want to do this without adding another "difference" column.

    I was thinking the formula might be along the lines of
    =COUNTIF(R2C2:R11C2,"<"&R2C3:R11C3)

    But this is wrong

    Can anyone help me please?

    x

  2. #2
    Registered User
    Join Date
    10-30-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: frequency or countif , comparing cells in 2 ranges

    Think I solved it myself... it's "=FREQUENCY(R2C2:R11C2-R2C3:R11C3,0)"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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