Results 1 to 3 of 3

<SOLVED> 2007: SUMIF not working when text is included in sum range

Threaded View

  1. 06-22-2010, 11:12 AM #1
    4am
    4am is offline
    Forum Contributor
    Join Date
    04-14-2008
    Location
    Fort Collins, Co
    MS-Off Ver
    2016
    Posts
    107

    Question <SOLVED> 2007: SUMIF not working when text is included in sum range

    Please see the attached workbook.

    Column I, daily cost is using the SUMIF function.
    Basically, if he attended daycare that day, it needs to add the daily cost (D), the cost for activity 1, (F) and the cost for activity 2 (H).

    The result is only giving me the daily cost.

    Please help!

    SOLVED: =IF(C4="Y",SUM(D4:H4),0) worked!
    Attached Files Attached Files
    Last edited by 4am; 06-22-2010 at 01:46 PM.
    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)

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