Forum Discussion
Solved
Determine total (sum) of individual items in 16 column x 200 row sheet
OK this might take some 'splainin' so ... I sell things online. Over 100 different things. I have a spreadsheet that tracks sales … Jane Doe, total sale, and a breakdown of what she bought b...
Another variant - sample
Hello Birch,
It would be nice to attach a screenshot (if possible) so that we can see what you're trying to do.
It would be nice to attach a screenshot (if possible) so that we can see what you're trying to do.
Suppose it would! Rows 1 through 10 are total tally area. Sales data starts on row 15. Sales data is entered into columns AJ through AX. (Cols A through AH are for accounting details pertaining to the sale). The SUMIF formula is in cells AJ8-10, AL1-10, and so on.
