LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default COUNTIF with or + and variables

---If you are looking to have the count as 1 for each row in Col J then try
the below in cell J1 and copy down

=IF(AND(OR(I1="A",I1="B"),K1="C",O1="C"),1,0)

---If you want the sum of the count you can use the below formula which will
get the count for the rows 1 to 100

=SUMPRODUCT((I1:I100={"A","B"})*(K1:K100="C")*(O1: O100="C"))

--
Jacob


"Dancest˜†r" wrote:
[i]

I'm having a hard time figuring this one out

My challenge is to count if column is "A" or "B" and column [K]
and [O] are "C"


I'm trying to count all the ones in column [J] that meet the specific
conditions.
I tried an array but it didn't seem to take.

Any hints are greatly appreciated.
.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF with 2 variables. HOW??? Patrick Excel Worksheet Functions 4 November 16th 07 04:48 AM
countif two variables in two different columns Greg Diamond Excel Worksheet Functions 2 May 25th 05 07:58 PM
Countif function with variables SMANDA Excel Worksheet Functions 0 February 7th 05 10:46 PM
another thought on COUNTIF 2 VARIABLES ?? Alan Excel Worksheet Functions 1 November 27th 04 03:25 AM
COUNTIF ON 2 VARIABLES ?? Alan Excel Worksheet Functions 4 November 26th 04 08:10 PM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"