Thread: count the # of times "name" is in E and "x" in F are in the same r
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default count the # of times "name" is in E and "x" in F are in the same r
Hi,

In 2007:

=COUNTIFS(E1:E9,"Shane",F1:F9,"x")

or if the name is in A1

=COUNTIFS(E1:E9,A1,F1:F9,"x")


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Nielly" wrote:

Not exactly sure how to describe it best. Just need a tally of the times a
two different names in two different columns are on the same row. Thanks!
Reply With QuoteReply With Quote