View Single Post
  #1   Report Post  
e_bone75
 
Posts: n/a
Default creating a function with multiple criteria

I am new to functions and formula. I want to write a simple formula that
will calculate the number of times a particular value occurs in a spreadsheet
using multiple criteria. I want to write a function that would calculatethe
number of times this situation is met-- how often does cvg, i, p and ch occur
in the same row.

cef i p me
cef i f me
cgs d f me
cgs d p ch
cvg d p ch
cvg i p ch
cvg i p ch

i hope this isn't too confusing... can anyone help?