+ Reply to Thread
Results 1 to 4 of 4

Summing up data if the cell beside it has a letter in it

  1. #1
    Registered User
    Join Date
    02-01-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2

    Question Summing up data if the cell beside it has a letter in it

    I want to sum up all the values from B4:B1000 (money) if the cell beside it, C4:C1000 has the letter "W" or "L" in it. I want these in two different cells to count the amount won and amount lost.

    I have tried =COUNTIF(C4:C1000,"L") for both L and W but neither work. Please help if you can, it is greatly appreciated! Thank you in advance .

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Summing up data if the cell beside it has a letter in it

    Maybe look into SUMIF function
    http://www.techonthenet.com/excel/formulas/sumif.php

  3. #3
    Forum Contributor
    Join Date
    06-30-2015
    Location
    Netherlands
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    145

    Re: Summing up data if the cell beside it has a letter in it

    Hi and welcome to the forum,

    try this: =SUMIF(C4:C1000,"L",B4:B1000) for Lost and =SUMIF(C4:C1000,"W",B4:B1000) for Win

  4. #4
    Registered User
    Join Date
    02-01-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2

    Re: Summing up data if the cell beside it has a letter in it

    Thank you for your help! Ill be on this forum a lot :D.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 25
    Last Post: 04-21-2015, 10:19 AM
  2. [SOLVED] Summing data based on several cell contents
    By JEB in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-05-2014, 07:33 AM
  3. If letter in cell then add row containing data from another sheet
    By falco8 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-29-2013, 07:52 AM
  4. Replies: 0
    Last Post: 07-10-2012, 08:37 AM
  5. Summing columns to matched symbol/letter for expense form
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2012, 12:11 PM
  6. Replies: 2
    Last Post: 10-12-2010, 09:14 AM
  7. Replies: 2
    Last Post: 07-26-2005, 03:05 AM

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