Hi!
Try this:
=SUMPRODUCT(--(A1:A7="cvg"),--(B1:B7="I"),--(C1:C7="p"),--(D1:D7="ch"))
Better to use cells to hold the criteria:
H1 = cvg
I1 = i
J1 = p
K1 = ch
Then:
=SUMPRODUCT(--(A1:A7=H1),--(B1:B7=I1),--(C1:C7=J1),--(D1:D7=K1))
Biff
"e_bone75" wrote in message
...
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?
|