Thread
:
COUNTIF Function
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Jill V[_2_]
external usenet poster
Posts: 1
COUNTIF Function
THANK YOU! =0)
you don't how many times i tried something.
"Bob Phillips" wrote:
=sumproduct(--(A2:A20="Y"),--(B2:B20="AD"))
--
__________________________________
HTH
Bob
"Jill V" <Jill
wrote in message
...
I have a spreadsheet with the following information:
Active? Type
Y GI
N AD
Y AD
N GI
I need to count how many AD with Y are in the sheet. Would I be using a
COUNTIF, DCOUNTA, or something else entirely? Please help!
Reply With Quote
Jill V[_2_]
View Public Profile
Find all posts by Jill V[_2_]