Query Count if Function QQQQssss

[Mark Fredenburg]

I have a range where Attendees of a convention either pre-register, Compted, Pre-register Only, or Register on site. For the on-site regitered they can register on Friday Saturday or Sunday. (that is a Different Range) I want to count "Registered" In the registered Range; From each Day EG Friday, Saturday, Sunday (Date Range)

I can countif Dates and Registered but how do I make it count on two different Cryteria

 

[Norman Harker]

Hi Mark!

You can use SUMPRODUCT as one approach to counting on more than one
criteria:

=SUMPRODUCT((WEEKDAY($A$1:$A$24)=1)*($B$1:$B$24="Registered"))

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

I have a range where Attendees of a convention either pre-register,

Compted, Pre-register Only, or Register on site. For the on-site regitered
they can register on Friday Saturday or Sunday. (that is a Different Range)
I want to count "Registered" In the registered Range; From each Day EG
Friday, Saturday, Sunday (Date Range)

I can countif Dates and Registered but how do I make it count on two

different Cryteria