Hey.
How do I get A1 to count whenever cell A2 has an A, B or C?
Thank you.
Hey.
How do I get A1 to count whenever cell A2 has an A, B or C?
Thank you.
Maybe
=--OR(A2="A",A2="B",A2="C")
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi DugiDug
Not sure what you mean by count, this will give a true if A1= A, B or C:
=OR(A1={"A","B","C"})
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Dosn't work: :S
I need it to count 1 as soon as there is an A, B or C in A2:A10?
OK.
A little more advanced now:
In D1 I wont to count 1, whenever A1:A10 has a D and whenever B1:B10 has either an "A", "B" or "C".
So D1 will show "1", when A1 has "D" and B1 has "B".
And D1 will show "2", when A1 has "D" and B1 has "B" + A3 has "D" and B3 has "C".
How will this look?
=SUMPRODUCT((A1:A10="d")*(B1:B10={"a";"b";"c"}))
Change the semi colons to comma if you have to do this.
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.
Dosn't work. :S
Works. ......................
It gives me: "?NAME#" when I try that.
Fixed that, now it shows "#I/T". :S
....................................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks