Hi guys, can you solve my problem with excel

Question

0.00/5 (No votes)

See more:

Excel-2016

I have been trying to count a number based on two range and criteria. but i can't solve it.
This is the data, i try to count how much cage between 100-200, 200-300 and if there was SPLIT count as +1 cage.

NO	Cage's	ABW(gr)	Ket	    RANGE	COUNT
1	NA02	491,04	SPLIT	100	TOTAL CAGE (SPLIT COUNT ONE)
2	NA05	710,99	SPLIT	200	TOTAL CAGE (SPLIT COUNT ONE)
3	NA07	172,95		    300	TOTAL CAGE (SPLIT COUNT ONE)
4	NA08	266,66		    400	TOTAL CAGE (SPLIT COUNT ONE)
5	NA09	529,19	SPLIT	500	TOTAL CAGE (SPLIT COUNT ONE)
6	NA12	463,06	SPLIT		
7	NB01	778,13	SPLIT		
8	NB02	927,84			
9	NB06	781,99	SPLIT		
10	NB07	721,78	SPLIT		
11	NB09	42,00			
12	NB10	935,68	SPLIT		
13	NB12	498,63			
14	NC01	121,93	TRIAL BEROK		
15	NC03	41,38			
16	NC05	779,26	SPLIT		
17	NC06	41,38			
18	NC07	41,58			
19	NC11	537,20	SPLIT		
20	ND01	571,45	SPLIT

What I have tried:

i've trying using countifs + if but still does'nt get the answer

Posted 18-Feb-22 15:19pm

Sultan Akbar Lubis

Updated 18-Feb-22 19:54pm

OriginalGriff

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-02-18T19:54:00

Firstly, the data you show has nothing to do with what your problem states: Your cage values aren't numeric and don't even get lose to 100, let alone 300, and what "SPLIT count as +1 cage." means I have no idea.

But the important bit is that this is the wrong site entirely for this: we are not an Excel support site, we are software development - and while I use Excel quite a lot, this question a=has nothing at all to do with producing code.

Please take this to an Excel site - google will find you loads - and ask there. But think about what you are trying to do and rephrase your question so it relates to the actual data you show, as well as showing what cell formulas or whatever you have tried.