Results 1 to 8 of 8

Using SUM on an IF formula column

Threaded View

  1. 11-17-2021, 11:20 AM #1
    Shoequeeny
    Shoequeeny is offline
    Registered User
    Join Date
    11-17-2021
    Location
    London, England
    MS-Off Ver
    Microsoft 365 for Enterprise
    Posts
    4

    Using SUM on an IF formula column

    Hi,
    I have a column using a simple IF formula - basically gives either the outcome of a 2 or 4 depending on the letter inputted on another column.

    Ideally, I'd like to use the SUM formula on this column, so adding all the 2s and 4s up.

    However this doesn't appear to work on the output of the formula. Is there any workaround for this?
    Last edited by Shoequeeny; 11-17-2021 at 11:56 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Formula to compare column duplicates in a column & second column with dates
    By lancelotlink in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-15-2022, 05:38 PM
  2. Formula to look Column A and Column C and place Desired Outcome in Column E
    By bjnockle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2021, 11:22 PM
  3. Manually inputting a Date in a formula column; Without Losing the Formula for the column
    By aussiemight in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-03-2019, 07:57 PM
  4. [SOLVED] Formula to compare column 1 to column 2 and list items not in column 2.
    By mahalek1976 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-23-2016, 12:55 PM
  5. Formula or VBA: Update column H with the closest-matching column AB URL to Column B
    By IO4lZE in forum Excel General
    Replies: 2
    Last Post: 05-21-2015, 10:41 PM
  6. [SOLVED] need formula to this logic, A column number B column blank then C column desired name
    By vengatvj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-02-2013, 10:30 PM
  7. [SOLVED] What formula to use?:Sum column W if column Q equals 390 & column L equal McL
    By Carolyn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2006, 03:00 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