THIS FORMULA WORKS:
=SUMPRODUCT((('LK COMPLETE'!E4:E)="Addition/Remodel")*('LK COMPLETE'!AU4:AU))
THIS ONE DOESNT:
=SUMPRODUCT((((inPRODUCTION!R3:R)="LK")*(inPRODUCTION!E4:E)="Addition/Remodel")*(inPRODUCTION!P3:P))
I'M TRYING TO narrow in on 2 text criteria and then totaling my stat? Example:
('LK COMPLETE'!E4:E)="Addition/Remodel") AND (inPRODUCTION!R3:R)="LK") then SUM(inPRODUCTION!AU4:AU)
Help?
THANK YOU IN ADVANCE!
The first formula doesn't work in Excel unless E and AU are named ranges. Google Sheets?
I suspect you want
=SUMPRODUCT((inPRODUCTION!R3:R = "LK") * (inPRODUCTION!E3:E = "Addition/Remodel") * inPRODUCTION!P3:P)
Last edited by shg; 08-06-2018 at 03:05 PM.
Entia non sunt multiplicanda sine necessitate
oops! Totally google sheets!
Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!
- Use concise, accurate thread titles.
- Your post title should describe your problem, not your anticipated solution.
- Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
- Responding to a request to change your thread title by doing so is mandatory.
To change a title go to your first post, click EDIT then Go Advanced and change your title.
No help to be offered, please, until the OP complies with this request.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
For one thing, you have a mix of row 3 and row 4. For SUMPRODUCT to work the size of the ranges being compared must be equal. It doesn't matter where they are and if they are vertical (rows) or horizontal (columns) or a mix as long as they have an equal number of cells.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Not quite sure how that is working. It seems like your range is not defined (e.g. E4:E gives me a NAME error). But, if you somehow have it working, then one possibility is that one some ranges start at offset 4, and the other one ("LK") is starting at 3. Ranges for these types of equations need to be the same size.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks