Hello,
"example attached" Forum Question_2.xlsx
I have 2 columns. First - # of items, second - priority. I need to count a number of items of a certain priority. Please help
Thank you!
Hello,
"example attached" Forum Question_2.xlsx
I have 2 columns. First - # of items, second - priority. I need to count a number of items of a certain priority. Please help
Thank you!
Last edited by Royser12345; 03-03-2014 at 06:54 AM.
Have you tried =COUNTIF(C:C,1)?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I don't think this is what I need. I need a count of items in column 1 based on the priority they belong in column 2
Fotis1991, thanks for pointing at the proper rule. Title has been changed accordingly. Regards,
Why do you say that Sambo kid's suggestion does not works for you? That formula gives the number 3 as a result which for your example is correct.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
So you mean, perhaps:
=SUMIF(C:C,1,B:B)
Regards
apologies perhaps for not being accurate enough in describing the problem... I am only doing my best
in my case the correct answer would be 132 which is the sum of indeed 3 priority 1 items. So I need a formula summing values in the 1 column based on the criteria (priority) in the second column
So you need to ADD-SUM the numbers.Not to count these..
So your solution is in post#6!
XOR LX, Fotis1991, Sambo Kid thanks a lot for your help, problem solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks