LinkBack URL
About LinkBacks
I am trying to sum the totals in row 73. I only want it to sum the cells that that the current year in the corresponding cell in row 75
4-8-2016 3-31-22 PM.jpg
I am trying to sum the totals in row 73. I only want it to sum the cells that that the current year in the corresponding cell in row 75
4-8-2016 3-31-22 PM.jpg
It's an array formula, confirm with CTRL+SHIFT+ENTER not just ENTER key.
=SUM(IF(YEAR(B75:Z75) =2016), B73:Z73, 0))
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Try this...
=SUMPRODUCT(--(YEAR(C75:J75)=YEAR(NOW())),C73:J73)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
error messages with both
What's the message?
If the formula returns a #VALUE! error that means your dates, or some of them, are not true dates. They're TEXT strings that look like dates.
Re: how to sum row if = current year
SUMIFS can do that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks