Hi,
I want to check if Column A contains word "Car" and Column B contains "Open" then Count Column "C" values and return it in Column D.
Thank you
sss.PNG
Hi,
I want to check if Column A contains word "Car" and Column B contains "Open" then Count Column "C" values and return it in Column D.
Thank you
sss.PNG
to count use countifs(A:A,"car",b:b,"open"). But I assume that you want something else and you haven't explained clearly.
Click the * to say thanks.
What do you mean by 'Count Column 'C'"? Word 'Called' is in there.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Hi Kokosek,
Thanks for the advance.
I mean I want to check IF Column A value (example "Car") and Column B Value(example "Open") then count the values in Column C
What do you mean by count value if in C2 is word 'Called'?
It have to be counted as 1 (because exists)? If in C3 is 'No action' it have to be 'counted' as zero?
Yea kokosek, As u said It should be return counted value of Column C .
Here In Column C has value "Called" so it means it has a value. So in Column D, it should be 1
First of all, makes no sense. Are you saying to count if a=car,b=open any values in C? or a=car,b=open,c=some value? Use countifs with 2 or 3 criteria.said It should be return counted value of Column C
something like in post #2 or =countifs(a:a,a2,b:b,b2) or ==countifs(a:a,a2,b:b,b2,c:c,c2)
It's like this
if a=car,b=open then count c
I am still confused but maybe:
Formula:Please Login or Register to view this content.
solve you needs.
actually its not working friend.
Here I attached the orriginal file. In first pic is the detail file and the second one is the summery. (I marked red) there need to show no wise( counting from Corrective Action ) how many action took for the MB Sales and Raised status . hope now is clear.
01.PNG
Attachment 650948
I give up so far....
Maybe fact that is Friday and my brain start going on stand by for weekend.
Is not you, can assure you of that. The problem is in this thread.Maybe fact that is Friday and my brain start going on stand by for weekend.
Try this, @Yroxmk : =countifs(a:a,"M/B Sales",E:E, "Raised",C:C,"<>")
I honestly have no clue. Is a simple countifs involved, but the OP makes it hard to resolve.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks