If no Array formula and no Sumproduct, what can I use?
I have been trying to create a product cost calculator where every column is a finished product and every row is a raw material. I am really bad with formulas but I had success with both Arrayformula and Sumproduct in Google Spreadsheets. But I need my data in Smartsheet and I can not calculate the cost of one product. Do you have any ideea on what should I use? Maby an example? Thanks
Help Article Resources
Check out the Formula Handbook template!