LinkBack URL
About LinkBacks
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
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.
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 mean, perhaps:
=SUMIF(C:C,1,B:B)
Regards
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
Fotis1991, thanks for pointing at the proper rule. Title has been changed accordingly. Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks