Hi, im posting from mobile device...
Is there any function that i can find a specific text from a range by a criteria ? Like =find(range,criteria) .. this is an example...
I'm searching for a formula very similar to =sumif... instead of [sum_range] i want to be 'logical' ...
Might be able to use MATCH with INDEX
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Perhaps
=COUNTIF(range,criteria)>0
Ok, i think i found something but i don't know how to combine the formula and count how many times is happening by the condition i created...
Formula:
Please Login or Register to view this content.
this is the formula, but i want to count how many times is happening by the sumifs > than other like in the formula
Will you please attach a sample Excel workbook? Nobody wants to have to recreate your data from scratch.
1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).
4. Try to avoid using merged cells as they cause lots of problems.
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.
Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Where is 1 with red there should be 2
Sorry, i forgot to upload it
you can probably do something with sumproduct. its pretty flexible but im not sure what your trying to achieve in your results...... why should it be a 2...... what are the references at the top?
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
because i have =IF with value TRUE = 1 and FALSE = 0 ... and it gives me 1 because the value is true but i want to count this true values... i tried to combine with countif and countifs but i don't figure it out..
im sorry im just really dont understand what you are trying to actually do....
this formula will give you a 1 for eeach time chelsea wins and sum it but whats the rest abotu and whats that to do with the numbers above.....
Please Login or Register to view this content.
this is good but i want and d3:d7>e3:d7.. that means 1/1....... 1 (G3:G7>H3:H7) / 1 (d3:d7>e3:d7)
im totally lost now. im really sorry, i am try to understand but i dont.
maybe if you fill the tabe out with what you expect to see maybe i could figure out a formula to replicate it....
Sorry if i don't spell like it should be..Originally Posted by twiggywales
1/1 means Half time / Full time...
If chelsea - tottenham is 1-0 at half time and 2-0 at full time
, this means g3:g7>h3:h7 (1>0) at half time and d3:d7>e3:e7 (2-0) at full time and all this i want to count as 1... what you give me it was only for half time... the result is 2 and is good from your formula but i want to include and full time (d3:d7>e3:e7).. do you understand now ?
Maybe lol
try this?
checks team and returns a one for each time both conditions are metPlease Login or Register to view this content.
Lol, so simple, haha! Thank you so much... if we both were from the same town i would bought you a beer... sorry for my english.. i have problems on spelling :D
Thanks again! You're the best!
glad to have helped. remeber to mark solved. :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks