Countif Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct 2
Query Count if Function QQQQssss 1
Sorting and COUNTIF 6
Excel Countif cell has diagonal border 6
COUNTIF, Sorting, on Two Sheets 1
Data collation 2
countif 3
=Countif(range, criteria) 2

Back
Top