Actual Language for Nesting criteria

[Judy Rose]

Have a system that is tracking scheduled appointments and appointment types,
need to program the formula to calculate overall appointments scheduled for
the month (that I can handle, here is my nest...) break out the sum to show
the number of initial appointments and number of secondary appointments
scheduled for the given month based on an indicator. Basically after I
program the countif date (A:A) for the given month how to add the programming
to count number for given month that are also priority indicator 1, 2, 3 for
the one column or 4,5,6 for the other?

I am not a programmer, just a tinkerer so need tons of help with the language.

Thank you for your help.

 

[Pete_UK]

You can only use COUNTIF when you have a single condition. For multiple
conditions you will need something like this:

=SUMPRODUCT((condition1)*(condition2)*(condition3))

Don't let the name of the function put you off - this COUNTS whenever those
conditions are all met.

A condition might look like:

(A1:A100=1)
or
(MONTH(D1100)=7)

Note that you can only use full-column ranges in XL2007 or later.

Hope this helps.

Pete