I have this formula which SUMS the number of products ordered. It
is able to count each item based on a string, however when there
are multiple items in one cell it is unable to count pass the
initial item.
I can have separate cells for each item, but keeping all ordered
ones in one cell is best to separate customers.
Each formula is in Column I 14-16 as an example.
=SUM(IF(ISNUMBER(FIND(H15,$F$5:$F$12)),VALUE(LEFT($F$5:$F$12,FIND(H15,$F$5:$F$12)-1)),0))
Attachment 672965
Last edited by AliGW; 04-18-2020 at 01:36 AM.
try this
Formula:
Please Login or Register to view this content.
Unfortunately, this did not work.
The number and string are in the same cell so reading two different columns wont work.
I uploaded the Excel so that it was easier to see what I was trying to do, since the PDF did not show cells
Last edited by Vyere; 04-17-2020 at 12:16 PM.
In F7; Length of "2 - Key" is not matching with formula. I mean, as it is at the second line of a cell, value(left(... combination starts to count from the first line and cannot find the data at the second line.
Is it not possible to divide them into two different cells?
As of now, I am putting them into separate cells. But keeping each in a single cell would be the easiest way to distinguish different orders.Originally Posted by macen
You did not give a representative sample of your actual workbook, but,
"... keeping all ordered ones in one cell is best to separate customers...."
can't possible be true. Each customer, and each invoice/record per customer should be a separate row.
stock =Sheet1!$F$7:$I$11
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks