+ Reply to Thread
Results 1 to 2 of 2

simple formula

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Finland
    MS-Off Ver
    Excel 2007
    Posts
    4

    simple formula

    Hello, i got this tiny problem with simplish(?) formula

    a1 = date
    b1 = number
    c1 = number
    d1 = date
    e1 = number
    f1 = number
    etc..

    sum of year 2013
    sum of year 2014

    if a1 year = 2014 take number only b1(ignore c1) and add it to sum of year 2014

    This is what i got now on my hidden calculate row. Problem is that it also pops the c1 value on this row too
    =IF(YEAR(A1=2014);B1;0)

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: simple formula

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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: 12-07-2012, 11:49 AM
  2. Need a simple formula for this...will you help me in this???
    By mgnidhi in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-10-2010, 06:44 AM
  3. Simple formula help
    By Vasant Nanavati in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] Simple formula help
    By zero in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. Simple formula help
    By zero in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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