Results 1 to 4 of 4

Thread: Need help with an Excel formula [Resolved]

  1. Aug 29th, 2004, 02:59 PM #1
    MartinLiss
    MartinLiss is offline

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    Need help with an Excel formula [Resolved]

    Given the following data, I'd like the sum of data in column B where column A is "good".

    A_________B
    good______10
    good______20
    good______10
    bad_______99
    bad_______99
    good______10

    So in this case I'd like 50 to appear under column B.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  2. Aug 29th, 2004, 03:46 PM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263
    Seems like you need a hidden column C

    With a formula like =IF(A1="GOOD",B1,0)

    Dup that - sum it at the bottom and put the total in column B...

    Don't have EXCEL on this workstation - so I could have bad syntax...
    Reply With Quote Reply With Quote
  3. Aug 29th, 2004, 04:17 PM #3
    MartinLiss
    MartinLiss is offline

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    Thanks. I got help from someone else and this works without a hidden column.

    =SUMIF(A:A,"good",B:B)
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  4. Aug 29th, 2004, 05:09 PM #4
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263
    EXCEL - what a mystery

    I have a colleague I always call on for stuff like this - I didn't even know there was a SUMIF function - but it sure makes sense in this respect...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width