View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
2many#s 2many#s is offline
external usenet poster
 
Posts: 1
Default Functions/Formulas to count multiple variables

Thanks in advance for any help you may have. Not sure if I need to use IF,
COUNTIF, ARRAY...etc.

I need to count a variable for one cell based on the variable in cell two.

Example - Need to count codes for multiple locations:
Location 1 codeA codeB codec
Location 2 code3 codeX code12

Need to know all of Location 1's codeA, codeB, etc.

This is probably an easy fix, but I'm stumped.