Skip navigation

proper syntax of a condition argument containing a cell reference and a comparison operator

347 Views 7 Replies Latest reply: Apr 17, 2013 9:57 AM by kwizs RSS
kwizs Calculating status...
Currently Being Moderated
Apr 15, 2013 3:18 PM

I'm using a SUMIFS function to compile the values of tools bought for my business in a given year. I don't know how to upload a screenshot, as I see has been done in some other discussions, so I'll make do with pasting my formulas and trying to describe what I'm doing.

 

=SUMIFS(Itemized Listing :: B,Itemized Listing :: ACQUIRED,A2,DISPOSED,"")

This is the basic formula I'm using, and it works as it is. The first condition stipulates that the value in the test range (Itemized Listing :: ACQUIRED) equals the value in (A2). The problem arises when I try to include a comparison operator in the argument:

 

=SUMIFS(Itemized Listing :: B,Itemized Listing :: ACQUIRED,<A2,DISPOSED,"")

returns a syntax error

 

=SUMIFS(Itemized Listing :: B,Itemized Listing :: ACQUIRED,"<A2",DISPOSED,"")

returns a syntax error

 

=SUMIFS(Itemized Listing :: B,Itemized Listing :: ACQUIRED,"<"A2,DISPOSED,"")

returns a syntax error

 

=SUMIFS(Itemized Listing :: B,Itemized Listing :: ACQUIRED,<"A2",DISPOSED,"")

returns a syntax error

 

It's got me stumped. Help, please?

iMac, Mac OS X (10.7.5)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.