Hello everyone,
Here is my issue :
I want to use this =COUNTIF(Clients!B4:B500,"**") formula on Column C but inside the ** i want it to automatically get the word thats on column A.
Anyone has any suggestions??
Thanks in advance.
Hello everyone,
Here is my issue :
I want to use this =COUNTIF(Clients!B4:B500,"**") formula on Column C but inside the ** i want it to automatically get the word thats on column A.
Anyone has any suggestions??
Thanks in advance.
Like this?
Please Login or Register to view this content.
Bramz
Try:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Wow cant believe I missed the whole propose of what you needed thanks Olly for fixing it
Thanks for the reply's both of u guys but it doesn't seem to work with what u said and instead i used this
=COUNTIF(Clients!$B$4:$B$500,"*"&Sheet2!$A$3:Sheet2!$A$500&"*") but now i have another issue.
This formula cant see the blank shells in sheet2 and counts them all the same.
Got any idea about an IF statement i can use to check for empty shells in column A sheet 2?
That formula doesn't make sense.
Can you attach a sample workbook? Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
one.PNG This is my client sheet and the products go on column B.
second.PNG And this is my Warehouse sheet.
In the Warehouse sheet i will put a lot of products on column A and their amount on column B.
What i want is when i put one of the products on client sheet column B to tell me how much i have
on Warehouse sheet Column C.
I just want to count how many of the products i have sold by their name.
What i want is to be able to put a formula on Warehouse sheet column C that can look
what name i have on column A(warehouse sheet) look for that name on client sheet column B
and tell me the amount.
One restriction i have is that clients may buy 2 or 3 different items so i want the formula to be able to count
that specific item out of 2-3 that are on the same sentence, all the items will be separated with a comma.
(ex. item1,item2,item3)i want to be able to see the difference and count them where it needs to).
I can't work from images, and I'll be damned if I'm re-keying your data. Please, attach a workbook. Please include some sample product data, and an example (manually mocked up) of what your required outcome actually looks like.
Here is my workbook , as u can see on sheet 2 column C every shell that doesn't have a value in column A
it counts all of them and if there is a value to compare it does it correctly.
Okay, so in sheet [Apothiki] cell C3, enter:
Formula:Please Login or Register to view this content.
and copy down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks