I am using a spreadsheet to keep track of orders. I am trying to find a way to count up my tally marks (X) per cell, but I also need it to multiply by how much product is in that column, across multiple columns and give me a total amount of product needed. Any help would be so appreciated!
Sample Spreadsheet.ods (14.2 KB)
The function SUMPRODUCT will perform what you want. See the modified example. Note that I changed the cells C2:E3 to numbers and I used the format of cell F3.
=SUMPRODUCT($C$2:$E$2,LEN(C3:E3))
It multiplies the arguments together, then adds them up, So it does C2 * len(C3) + D2 * len(D3) + E2 * len(E3) for the cell F3.
Sample Spreadsheet.ods (15.4 KB)
(Disclaimer: SUMPRODUCT is one of my preferred Calc functions…)
1 Like
Thank you for your help! I understand what you are saying but when I put that into my actual document all it returns is 0. I can’t figure out why
it isn’t working…
Items Needed List.ods (26.5 KB)
The contents of the colored cells representing quantities must be numbers. You have 2oz in C2 and it should be 2, and then format it with the same format as the total column.
I figured it out. The oz on 2oz is wrote as a number. #.##“oz”. Thank you for all your help! I am so greatful!