Results 1 to 5 of 5

Sum different # cells

Threaded View

djones13 Sum different # cells 05-28-2011, 06:51 PM
jeffreybrown Re: Sum different # cells 05-28-2011, 07:01 PM
djones13 Re: Sum different # cells 05-28-2011, 11:41 PM
Haseeb Avarakkan Re: Sum different # cells 05-28-2011, 11:55 PM
Marcol Re: Sum different # cells 05-28-2011, 09:53 PM
  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Orem, Utah
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    4

    Arrow Sum different # cells

    Alright, I'm doing a COUNTIF statement, but I'll need to count different sizes of lists, so I won't be able to have an exact range. Example: COUNTIF(C4:C11,"APPLE") Because, the next one will be this: COUNTIF(C13:C16,"APPLE") so I wouldn't just be able to copy paste it.
    In the real world application, there will be hundreds of these lists everyday that I'll have to count a certain text out of a list.
    Attached is the FRUIT COUNTIF to play with and find a solution
    Attached Files Attached Files
    Last edited by djones13; 05-29-2011 at 12: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