=SUMIFS(Itemized Listing :: B,Itemized Listing :: ACQUIRED,"<"&A2,Itemized Listing :: DISPOSED,"")
I've assumed that DISPOSED is a column on the itemized listing table.
Conditions must be expressed as a text string. the quotes ensure that < is recognized as text, not an operator. The concatenation operatot ( & ), outside the quotes, appends the contents of A2 to the text string.
I haven't checked on the second condition.
Thank you, that works. I'm still not sure why the concatenation function is necessary; it seems that a cell reference should be able to be part of a string. Whatever, I'm glad to have the problem solved, I just thought the answer would be a bit more intuitive.
A tangential question: Do you have a quick explanation for how to include a screenshot as a demo in these question forms?
"A tangential question: Do you have a quick explanation for how to include a screenshot as a demo in these question forms?"
There are four types of screen shots. Procedure for all is similar:
Portion of screen
Press shift-command-4. Drag to enclose the desired portion of the screen. Release mouse button to take the shot.
Press shift-control-command-4 Drag to enclose the desired portion of the screen. Release mouse button to take the shot.
The one on the bottom left is suitable for inserting in this forum. Click the camera icon above the composition space, then follow the prompts.