+ Reply to Thread
Results 1 to 5 of 5

How to Add Totals in a column with If Then Statements

  1. #1
    Registered User
    Join Date
    09-15-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    2013
    Posts
    64

    How to Add Totals in a column with If Then Statements

    attached sheet. i have data in Column B and C, and Column E and F show the higher value in Column B and C using If, Then Statements. so for instance,in row 4, Column C won, so i have a "1" placed in Column F. i then want to add the total "1's" for the columns in Cell E1 and F1, but it shows a 0. how do you get it to add up the 1's?

    thank you
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: How to Add Totals in a column with If Then Statements

    use
    =IF(C4>B4,1, "")

    instead of =IF(C4>B4,"1", "")
    just remove " quotation symbol" around 1
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

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

    Re: How to Add Totals in a column with If Then Statements

    Change "1" to 1.

  4. #4
    Registered User
    Join Date
    09-15-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    2013
    Posts
    64

    Re: How to Add Totals in a column with If Then Statements

    gosh, easy fix! thanks guys and gals!

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: How to Add Totals in a column with If Then Statements

    Try not to use manual alignment. Numbers are automatically right signed, text, left-aligned. Your mistake then becomes easier to find

+ 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: 4
    Last Post: 02-10-2019, 04:36 PM
  2. [SOLVED] Sorting one column from a table using SUMed totals in that column
    By leighdaly in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2014, 02:23 AM
  3. Using IF statements to create totals where words are involved
    By 'MMSA_MAX in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 08:45 PM
  4. Replies: 3
    Last Post: 08-01-2006, 08:15 PM
  5. Cant get totals to work with IF statements
    By spelingchampeon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-09-2005, 10:14 AM
  6. Calculating totals in a column based on a lookup in another column
    By Michael Wright via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2005, 05:06 AM
  7. [SOLVED] Comparing/matching totals in a column to totals in a row
    By Nicole L. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2005, 07:06 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