I've solved the problem (based on current drop down selections) by manual entry. I still want to use an array, but I can't figure out how to reference the cells with the data... I've tried concatenating, too, but I can't get the syntax right.
File attached, thanks!
Hi,
If my understanding is correct, try this formula :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
OK Try this:
=SUM((Name=I4)*(Dater>=I5)*(Dater<=I6)*(Sales))
CSE the above. See the attached.
CSE for SumIfs.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Ah yes, asterisk for and... I understand, thanks!Originally Posted by MarvinP
Re: Array Syntax for Cell Referencing
Excellent.. While the asterisk for and logic in the array is a little cleaner, I appreciate the help with the concatenation syntax here.Hi,
If my understanding is correct, try this formula :
Please Login or Register to view this content.
No need for the SUM function:
=SUMIFS(Sales,Name,$I$4,Date,">=" & $I$5,Date,"<="&$I$6)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks