Forum Discussion
Solved
How is this achievable?
Hello folks, A few moths ago I started a new job and I did for them a simple table with list menu, and then a table where you get summarized data, with SUMSIF, for each menu item. Now they want m...
Please see the attached document. As i did, remove all the merged cells in your document and all error messages as well. Please make sure that entries in the cells colored in black are removed as well. Some of these cells have error messages or numbers "1" or "2".
=SUMPRODUCT(($A$5:$A$69=$I29)*($B$5:$B$69=$J29)*($C$5:$C$69=$K29)*D$5:D$69)
Enter formula in cell L29 and copy across range L29:O100. It works fine in my excel sheet.
I uploaded an example, is it working?
Yes, apart from the #REF errors in the left-hand table.
In your example, the table on the right is more or less a copy of the table on the left. It does not make clear what exactly your problem is.
In your example, the table on the right is more or less a copy of the table on the left. It does not make clear what exactly your problem is.