Countif Q

's Computer Specifications

I'm trying to Count the number of instances of "Yes" in Column A (sheet2)
BUT only if the values in Column A (sheet2) = to a value I have in C8 in
Sheet1

Column A and Column B on sheet2 are both of equal length.
C8 = a date
ColumnA = a range of different date

Thanks

's Computer Specifications

Sorry my "Yes" and "No" texts are in Column P, not Col A

"John" <r.@9999yahoo.co.uk> wrote in message
news:du2j3q$jc5$(E-Mail Removed)...
> I'm trying to Count the number of instances of "Yes" in Column A (sheet2)
> BUT only if the values in Column A (sheet2) = to a value I have in C8 in
> Sheet1
>
> Column A and Column B on sheet2 are both of equal length.
> C8 = a date
> ColumnA = a range of different date
>
> Thanks
>
>

's Computer Specifications

Got this from a posting by Arvi Laanemets

=SUMPRODUCT((P2:P165="Yes")*(A2:A165=Report!C8))

"John" <r.@9999yahoo.co.uk> wrote in message
news:du2j3q$jc5$(E-Mail Removed)...
> I'm trying to Count the number of instances of "Yes" in Column A (sheet2)
> BUT only if the values in Column A (sheet2) = to a value I have in C8 in
> Sheet1
>
> Column A and Column B on sheet2 are both of equal length.
> C8 = a date
> ColumnA = a range of different date
>
> Thanks
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF is Off by 1	GooseMA	Microsoft Excel Misc	4	8th Dec 2009 05:04 PM
Can I use COUNTIF with OR?	AA Arens	Microsoft Excel Discussion	3	20th Nov 2006 04:11 PM
How do I use a countif function according to two other countif fu.	=?Utf-8?B?S2lyc3R5?=	Microsoft Excel Worksheet Functions	2	20th Feb 2006 11:44 AM
COUNTIF or not to COUNTIF on a range in another sheet	=?Utf-8?B?RWxsaWU=?=	Microsoft Excel Worksheet Functions	4	15th Sep 2005 10:06 PM
COUNTIF in one colum then COUNTIF in another...???	=?Utf-8?B?Sm9ubmllUA==?=	Microsoft Excel Worksheet Functions	3	22nd Feb 2005 02:55 PM