Thread: Count rows where a specific value appears in any of 4 columns
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Count rows where a specific value appears in any of 4 columns
You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LisaM" wrote in message
...
Hi Ashish,

Thank you for your help. This does this job!

Lisa

"Ashish Mathur" wrote:

Hi,

In column E, use the formula COUNTIF(A2:D2,1)0 and copy all the way down
to
row 5807. Now in a spare cell, use the formula =COUNTIF(E2:E5807,TRUE)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

Reply With QuoteReply With Quote