Dear Friends,
I create formula there is #VALUE! error.
I use SUMPRODUCT. Details I put on attached file.
Thank you in advance for your help
Regards,
Wie
Dear Friends,
I create formula there is #VALUE! error.
I use SUMPRODUCT. Details I put on attached file.
Thank you in advance for your help
Regards,
Wie
SUMPRODUCTS (and SUMIFS) require ranges to cover the same rows or columns)
In addition the INT(A:A) doesn't work so add a helper column N to the data with
Formula:Please Login or Register to view this content.
also take the trailing spaces out of the Laporan sheet tab name.
Then B2 copied across and down is
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
In SUMPRODUCT all the ranges have to have the same shape
=SUMPRODUCT('Laporan Mutasi Transaksi '!$I$4:$J$20*(INT('Laporan Mutasi Transaksi '!$G$4:$G$20)='Summary Transaksi'!C$1)*('Laporan Mutasi Transaksi '!$I$3:$J$3='Summary Transaksi'!$A2))
You are trying to use a range with two columns against two other ranges with one column.
Please describe what you want this formula to do, rather than how you are trying to do it.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hi Jeff and Richard,
Thanks a lot for your advise. I have new knowledge.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks