plaw;192468 Wrote:
I need a countif formula that will function with two requirements in two
separate columns. So essentially it only counts if it matches the two
requirements.
That's more likely a SUMPRODUCT formula, for example:

=SUMPRODUCT(--(A1:A100="cat"),--(B1:B100="red"))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=53043