hy guys i got a hard example here. i need to count all the time two criterias meet. i put an atachement so u can see. so i need to count all the times B18=1 and c35=1, then B52=1 and C68=1, etc. i need to put the result in only one cel. please help me!
i cant put a atachement and i dont know why?
its ok now with the atachement
Last edited by saintdevil8; 10-08-2017 at 11:29 AM.
1 0 1 3 times
0 1 0
1 0 1
0 1 0
1 0 1
1 0 2
No attachment!
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I am not getting. Do u want to simply count the numbers?
Whom are you addressing? Thank you for the attachment.
no, i want to count every time there is this condition b18=1 and c35=1, b52=1 and c69=1, b103=1 and c120, etc, so there are 3 times. u understand now. i nedd to let the spacing between the numbers.
Having looked at the attachment, I am sorry, but I have no idea what you are trying to achieve.
i put a biger atachement, so maybe now its clear, u wil see on E column what i need to count.
No, sorry - it's not clear at all. Explain in words when a number one should be counted and when it should not.
sorry for the exprimation but my english sucks
Is this what you need?
=COUNTIFS(B1:B1055,1,C18:C1072,1)
So does my telepathy ...Originally Posted by saintdevil8
sorry for the exprimation but my english sucks
omg, thats awesome, its what i needed, thank you very much, and i wish you a good week
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks