Results 1 to 11 of 11

Formula for counting values in different columns/rows

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2015
    Location
    outerspace
    MS-Off Ver
    not sure
    Posts
    17

    Formula for counting values in different columns/rows

    Hi all,

    I need assistance in sorting out the following:
    I have column A that contains several fields, like apples, bananas etc.. on each row of this column i have another value containing the status, for example purchased, not purchased.

    I need a formula that can tell me how many apples were purchased and how many were not.
    In the attachment its much clearer.

    Thanks for your help...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting occurrences not values.. Counting blocks of words in columns
    By Flydd in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-01-2016, 06:42 PM
  2. Need to Paste Values from Formula into Columns with Different Numbers of Rows
    By VBAnewbie9314 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2014, 08:46 AM
  3. [SOLVED] formula to determine how many rows have different values in two columns (mismatches)
    By shardin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2014, 07:41 AM
  4. Replies: 1
    Last Post: 02-18-2013, 01:46 AM
  5. Avoid counting rows/columns with formula but no values
    By magnuc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2006, 06:30 AM
  6. [SOLVED] [SOLVED] Counting rows, then counting values.
    By Michael via OfficeKB.com in forum Excel General
    Replies: 7
    Last Post: 08-04-2005, 06:05 PM
  7. [SOLVED] Counting Rows Then Counting Values in Columns
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1