On 2002-12-17 13:27, SCSA25 wrote:
here is the logic I am shooting for
If C1 contains "Pilot" then CountA(A9:A200)*6,if C1 contains "Bic" then CountA(A9:A200)*7
Does this work?
try a nexted ifOn 2002-12-17 15:06, SCSA25 wrote:
Yes it is
Generic Example
Cell A Cell B
1Division Mechanical Pencil
2Product Name Pilot 2300 Pencil
3Product # DA12345