As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/

Options

The Cat
Registered User, ClubPA regular

OK, what I'm trying to do is get a formula to return the number of instances in a worksheet where one column has Value X *and* the column next to it has Value Y.

So, if figured I could use COUNTIF with multiple criteria. Apparently this doesn't work, only Excel 2007 can handle that by using a new function called COUNTIFS. That's nice, but I work for the government and therefore won't see Office 2007 until maybe 2020. Is there a workaround to get what I need in Excel or OOCalc?

So, if figured I could use COUNTIF with multiple criteria. Apparently this doesn't work, only Excel 2007 can handle that by using a new function called COUNTIFS. That's nice, but I work for the government and therefore won't see Office 2007 until maybe 2020. Is there a workaround to get what I need in Excel or OOCalc?

0

## Posts

Make a column with the following formula:

=IF(A=X, IF(B=Y,TRUE,FALSE), FALSE)

where A and B are the appropriate column / cell references

Then do a COUNTIF(C, TRUE) where C is the range of cells containing the above formula.

If necessary, you can hide the column to make your worksheet pretty.

Nerissaonthanks!

The CatonKnuckle Draggeron- John Stuart Mill