LinkBack URL
About LinkBacks
Hi all,
Thank you for your time and love for Excel.
My Eng isn't very well, so, is it POSSIBLE Sumproduct on UNEVEN cell ranges
Hi all,
Thank you for your time and love for Excel.
My Eng isn't very well, so, is it POSSIBLE Sumproduct on UNEVEN cell ranges
Do you mean like this?
Formula:
Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Please provide a sample sheet WITH expected answers, calculated manually.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
C2:C10 sum range rest are condition, F1:F5 reason for not use SUMIF or SUMIFS, for some strange reason SUMIFS stop working after two conditions, maybe bug in EXcel 2013?
Please Login or Register to view this content.
Thanks in advance God Bless us ALL
orig formula:
Formula is sitting in A2, here version w/o MATCH, is not working.Please Login or Register to view this content.
G2:G9029 sum range.
Problem is probably in that B1:B9 part
SUMIFS stops working after two conditions(B1, B2,..)
SUMIFS+SUMIFS+... is too long and too frustrating
Last edited by B.W.B.; 02-16-2024 at 09:57 AM. Reason: add some formula
Formula is in A2(Sheet3) and is not working, #N/APlease Login or Register to view this content.
Last edited by B.W.B.; 02-16-2024 at 10:11 AM. Reason: Lapsus calami
SUMIFS not working, one Workbook, three sheets
Please Login or Register to view this content.
I have already given you the solution.
Wrap conditions in ISODD ??
Not wrap.
ISODD(ROW()) multiplied by the rest of your conditions.
In the ROW function you just put a column from your data, doesn't matter which one.
Which range? Sum range?
Sorry did not saw your answer, WILL try and let you know
Last edited by B.W.B.; 02-16-2024 at 10:50 AM. Reason: Lapsus oculi
Still no sample file...
Here it is , sorry
In C2 formula, middle sheet
I changed a few values... it was hard to find the matches (5 in 10,000 rows... not a great sample file, which should be 10-20 rows and have some values that ACTUALLY work).
=SUMPRODUCT((--ISNUMBER(MATCH(eksport!$E$2:$E$10000,Sheet1!$B$1:$B$9,0)))*(eksport!$C$2:$C$10000=D11)*eksport!$G$2:$G$10000)
AS ALWAYS MR.GLENN, HATS DOWN, KUDOS, THANK YOU FROM MY HEART! Extraordinary!
Why this "twist" MATCH(eksport!$E$2:$E$10000,Sheet1!$B$1:$B$9, not other way around?
No problem. This:
MATCH(eksport!$E$2:$E$10000,Sheet1!$B$1:$B$9
returns 10,000 values, the other way round only 9... and SUMPRODUCT falls over 'cos the ranges don't match.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks