View Full Version : COUNTIF for more than 1 thing on the same formula
jzamilpa3
05-28-2008, 08:24 AM
i have 2 sheets where i need a countiff. i have on my first column a set of wording and on the first row i have the years. and i have my info on sheet 2 columnA is the years and columnB is the wording.
PLEASE HELP ASAP
godsowndevil
05-28-2008, 09:42 AM
You can try this:
=Countif(Range,"Condition 1")+Countif(Range,"Condition 2")+....
I hope this helps. :thumb
Bob Phillips
05-28-2008, 09:50 AM
What are you trying to count?
jzamilpa3
05-29-2008, 05:13 AM
i think thats the way i tried it and for some reason it didnt work. im tryin to count defective areas and parts that have been found in a specific year
Bob Phillips
05-29-2008, 06:01 AM
That doesn't really help, I meant in terms of the spreadsheets, what cells/columns/rows/values etc.
godsowndevil
05-29-2008, 09:33 AM
It may help better if you could attach a sample sheet
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.