5punk

I know this would be better done in a database, since it's a database query really, but I've run across it quite often in Excel and it's bugging me cos I can't make it work. I have a bunch of data with multiple variables and need to get a relational count. So for example:

Requirement / Priority / Met?

Reqt1, HI, Y
Reqt2, HI, N
Reqt3, LO, Y
Reqt4, MED, Y
Reqt5, HI, N

Count how many Reqt1 of Priority=H and Met=Y

Edit: just realised Excel 2007 has COUNTIFS which does this. My retardedly backward company is still on 2003.

Also, I could probably just use a pivot table.

There's probably a better way of doing it, but you could just make a fourth column, concatenate the other columns in it, then do a regular count if on that column.