LinkBack URL
About LinkBacks
Hi!
Got a simple question regarding the powerful countifs formula: Can I use the same cell as Criteria in multiple ranges?
All additional ranges have the same number of rows and columns as the criteria_range1 argument.
Hi!
Got a simple question regarding the powerful countifs formula: Can I use the same cell as Criteria in multiple ranges?
All additional ranges have the same number of rows and columns as the criteria_range1 argument.
The short answer is: Yes!
Yes you can.
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.
Then I must be doing something wrong. I`ve attached a file with a simple countifs formula in sheet1. What am I doing wrong?
Your formula seems correct.
The result is 'zero' since there are no entries where both columns (B&C) have the same entry i.e. 'A'
What is your expected result?
Life's a spreadsheet, Excel!
Say thanks, Click *
OR you mean?
=COUNTIF(B3:C8,B2)
Hi, and thank`s you for your answers.
I now see I`ve been inaccurate in describing my problem. See new file with more accurate description.
What I`m looking for is a formula that 1) looks up range K4:K25 = TRUE 2) looks up range C4:J24 = user data entry M4. I then would like to count and sum the intersection 1) and 2)
Try
=COUNTIFS(K4:K25,TRUE,I4:I25,M4)
=SUMIFS(J4:J25,K4:K25,TRUE,I4:I25,M4)
Tr this..
Counts
Sum
Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks Ace_XL, it works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks