+ Reply to Thread
Results 1 to 3 of 3

Operations on cells containing certain WORDS

  1. 01-29-2023, 01:17 PM #1
    student_md
    student_md is offline
    Registered User
    Join Date
    01-15-2022
    Location
    turkey
    MS-Off Ver
    2021
    Posts
    10

    Operations on cells containing certain WORDS

    How can we write the formula that finds the total number of students as in the green part? Please find attached Excel File.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by student_md; 01-29-2023 at 01:50 PM.
    Reply With QuoteRegister To Reply
  2. 01-29-2023, 04:05 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,975

    Re: Operations on cells containing certain WORDS 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 01-29-2023, 04:38 PM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,804

    Re: Operations on cells containing certain WORDS

    Another option
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need Formula to perform3 operations for multiple cells
    By Lois Goodsell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2020, 03:27 PM
  2. Freezing cells during filter operations
    By lparno in forum Excel General
    Replies: 0
    Last Post: 04-09-2013, 05:46 AM
  3. Operations considering with multiple cells
    By gerard_gonzales33 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-25-2012, 10:31 AM
  4. Performing operations on cells from previous worksheets
    By sollinton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2012, 05:45 PM
  5. Using named cells in operations
    By dwtaxguy in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-02-2009, 10:34 AM
  6. Using blank cells in mathematical operations
    By Sean Anderson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2008, 02:12 AM
  7. Operations with hidden cells
    By Hiughs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1