I have a worksheet that has multiple columns and I want to apply sumproduct to two of the columns if certain text in other columns are met and number order is met based on conditions found in other cells.
For example:
=sumproduct(--($B$15:$B$2997,$A$1),--($E$15:$E$2997,$a$2),--($D$15:$D$2997,$A$3),--($C$15:$C$2997,"<="&+$a$4),--($C$15:$C$2997,">"&+$a$5),$f$15:$f$2997,$j$15:$j$2997)
The formula is not working though. Any assistance is much appreciated.
Thanks
We do not allow duplicate threads. If you need to change your title please go to your original thread and edit the title, rather than starting over again in a new thread. The post by AliGW in your other thread explains how to edit your title.
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks