View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DSKR DSKR is offline
external usenet poster
 
Posts: 5
Default Counting occurances based on multiple variables

I have a range of cells that hold 4 possible entries and another range that
holds 3 possible entries. Is it possible to COUNTIF/SUMPRODUCT if you for
more than one possibile entry in a cell range?

Here's an example:

Corp Sales 15
Corp Retrn 20
Corp Excha 20
Corp Retrn 0
Corp Excha 15

I want to count the number of occurances when column B reads either Retrn or
Excha and column C reads 15 or 20. In this case, the formula would return 3.

Any help would be appreciated...