# simple formula

1. ## 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. ## 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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