Counting and Suming based on multiple criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kev270 - 12 Oct 2006 14:49 GMT

I need to get a count based on multiple criteria. I need to count if a
certain text value occurs in a column, but only if it meets a seperate date
criteria.

I have a data entry page with a vendor column and and month column. I want
to count how many times a vendor is listed in a certain month. I have tried
Count and Count IF formulas with out luck.

Reply to this Message

Bob Phillips - 12 Oct 2006 14:55 GMT

=SUMPRODUCT(--(A2:A20="text_value"),--(B2:B20>=--"2006-09-01"),--(B2:B20<=--
"2006-10-01"))

as an example

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I need to get a count based on multiple criteria. I need to count if a
> certain text value occurs in a column, but only if it meets a seperate date
[quoted text clipped - 3 lines]
> to count how many times a vendor is listed in a certain month. I have tried
> Count and Count IF formulas with out luck.

Reply to this Message