Hello,
I want to return total queued amount of each owner to its name in order to show the chart, how can I do that. ?
Regards;
Hello,
I want to return total queued amount of each owner to its name in order to show the chart, how can I do that. ?
Regards;
Try putting this in cell A2 on your "Sheet1" and then fill down:
=COUNTIFS(Sheet2!$O:$O,"*"&Sheet1!$A2&"*",Sheet2!$M:$M,"QUEUED")
I checked it .. it gives count wrong and not correct why ?
Because your names differ between sheets
But in A2 there is owner name,
for example owner salman, in the B2 there should be showing 22.
for example owner Mohamed, in the B2 there should be showing 10
I tested formula in A2 but it didn't work.
Don’t have an account yet? Register yourself now and be a part of our community!