Thread
:
Using COUNTIF and OR
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Using COUNTIF and OR
try this after changing columns to suit
=SUMPRODUCT((H2:H22={"a","b"})*(I2:I220))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Janie" wrote in message
...
I know COUNTIF isn't the right function because I know it cannot use logic
operators. Here's what I am trying to accomplish:
Col A Col B
A 5
B 6
C 3
A 3
A
B 7
The question is, how many numbers in Column B correspond to EITHER A or C?
Recommendations?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett