hello
im trying to sum multiple ranges based on my criteria using sumproduct but the end number i am getting is not right
=SUMPRODUCT((INDEX(_Data,0,1)=$C13)*(INDEX(_Data,0,5)=D$11),(INDEX(_Data,0,D$10)),(INDEX(_Data,0,E$10)))
if i add D10 + E10....i should 200K...but i am getting $1M using the formula above
can someone help?
column D10 and E10 contain text as well. :S
Hi
If it is an and condition try to use "*" in place of "," in between conditions
Regards
Please Login or Register to view this content.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
hey buddy
your formula should work...however the range contains text....so the )*( is giving me value error....any thoughts?
Hi
I am not sure, may try another array function sum(if(
Regards
Hi,
Can you upload the workbook.
Since you have XL 2007 have you considered the more efficient SUMIFS() function rather than the old SUMPRODUCT()?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks