UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sumif Based On Less Than, Office 2013    
 
   
likajoho
post Apr 14 2018, 09:25 AM
Post#1



Posts: 1,071
Joined: 18-February 04
From: Oklahoma


This should be easy, but it isn't working. So I must be doing something wrong.

I have a large array. Here are the relevant columns:
F - Tax Year
U - Previous Depreciation
AG - Depreciation Taken

Some of my calculations are based on previous depreciation, so I need to know the amount previously taken in total (cumulative-not including current tax year). Here is my formula which only works for the 2nd year - row 2

=Sumif($F$14:$F$29,F2-1,$AG$14:$AG$29) ---- this is only correct for the 2nd year

So I tried this instead:

=Sumif($F$14:$F$29,"<F2",$AG$14:$AG$29) ---- this returns $0

Please help. I'm stumped. I've tried everything I can think of.
Go to the top of the page
 
cheekybuddha
post Apr 14 2018, 09:52 AM
Post#2


UtterAccess VIP
Posts: 9,670
Joined: 6-December 03
From: Telegraph Hill


Hi,

Try:
=Sumif($F$14:$F$29,"<"F2,$AG$14:$AG$29)

Or:
=Sumif($F$14:$F$29,"<" & F2,$AG$14:$AG$29)

--------------------


Regards,

David Marten
Go to the top of the page
 
likajoho
post Apr 14 2018, 10:08 AM
Post#3



Posts: 1,071
Joined: 18-February 04
From: Oklahoma


The formula worked. Thank you so much! smile.gif
Go to the top of the page
 
cheekybuddha
post Apr 14 2018, 12:06 PM
Post#4


UtterAccess VIP
Posts: 9,670
Joined: 6-December 03
From: Telegraph Hill


yw.gif

--------------------


Regards,

David Marten
Go to the top of the page
 
« Next Oldest· Microsoft Excel· Next Newest »
 
Display Mode: Standard · Switch to: · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search
RSSSearch   Top   Lo-Fi    26th April 2018 - 08:11 PM