Hello, I'm new to this forum and just started a job in excelthings.
I have a whole table of multiple (3565) different orders coming from a "couple" (110) of producers.
I would like to get the frequency of these orders per producer but depending of the place where this order was set AND who transports the order, which are in different columns.
=> How many times did transporter A move an order from producer B (IF 1) too place C (IF 2)
I found a formula to implement 1 IF in the frequency formula but not multiple. This seems more difficult because of the way the IFS formula is set up. (test1, result1, test2, result2,...) since I only want 1 result I don't know how to proceed.
i hope my question is somewhat logical.
thanks in advance
Bookmarks