Countif Question

  • Thread starter Mark Fredenburg
  • Start date
M

Mark Fredenburg

I have range that has Registered, Compted, Pre-Registered, Pre-Reg. Only, in another colum I have a range that has Fri., Sat., Sun., (some attendees registered on Friday some on Saturday some on Sunday) All I want to do is count how many each day registered. I can make the piviot table give me a answer but i want something that is automatilcly updated throuought the convention. I would think i could use the countif which works on a single range but how can i work with two ranges?
 
B

Bob Phillips

=SUM PRODUCT(A1:A100="Registered")*(B1:B100="Fri"))

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Mark Fredenburg said:
I have range that has Registered, Compted, Pre-Registered, Pre-Reg. Only,
Click to expand...
in another colum I have a range that has Fri., Sat., Sun., (some attendees
registered on Friday some on Saturday some on Sunday) All I want to do is
count how many each day registered. I can make the piviot table give me a
answer but i want something that is automatilcly updated throuought the
convention. I would think i could use the countif which works on a single
range but how can i work with two ranges?
 
Top