LinkBack URL
About LinkBacks
I am trying to multiply (E) * (F), in (G) > If Dates in (B) Thru (C) = To a Full year , If not, do not multiply (E) * (F)
Mutiply rows if date columns equal to a full year
I am trying to multiply (E) * (F), in (G) > If Dates in (B) Thru (C) = To a Full year , If not, do not multiply (E) * (F)
Last edited by Whard42; 10-17-2018 at 01:39 PM.
We are not able to work with screenshots. Please attach a sample workbook instead. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Since there are no full years in B:C this returns all blanks in the upload.Formula:
Please Login or Register to view this content.
Dave
Are the numbers in G the expected outcome? If so, then do you mean a full month rather than a full year? And why are you wanting to multiply E and F? Should you not be adding them? Confused!
Yes, G is the expected outcome.
What I would like to do if possible is to have a formula that would see January 1, 2010 to December 31, 2010 as a full year.
IF date in B4:C23 = Full Year, add : ) column E and F. If not blank.
Right now, I can do it by entering “Year” in D, but I must tell it the date and that’s what I trying to avoid.
Thank you for your quick reply
How about this, then?
=IF(COUNTIFS($C$4:$C$23,">="&DATE(YEAR(C4),1,1),$C$4:$C$23,"<="&DATE(YEAR(C4),12,31))=12,E4+F4,0)
What was confusing at first was that you seem to have rows and columns muddled in your title, and you were saying multiply instead of add in your opening post. Columns have letters across the top, rows have numbers down the side.
Thank you.
Very greatly appreciated. I been messing with this for 3 days now.
Sorry for the confusion.
You're welcome!
It is pretty important to get rows and columns the right way around.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks