trying to build a count formula based on a condition

[ittiams]

I am trying to build a formula to come up with a count or sumif.
If a customer has no sales in 2011, but has sales in 2012 - then it is a new customer. I want to build a column with a count then sum it up to get a count.

I tried the difference of year 2 and year 1 to find out if greater than zero and equal to year 2 value. then if both values were zero - it would throw up a new customer.

Please help.

 

[NARAYANK991]

Hi ,

Can you explain what you want to do ?

Do you wish to flag a customer as new ?

If so , a simple IF statement checking for no sales in year 1 , and sales in year 2 will do.

Do you wish to total the sales of new customers ?

If so , can you use SUMIFS ?

Narayan

 

[ittiams]

Thanks Narayan. I am trying to compare two points and say if no sales in year 1, but sales in yr 2, then new customer.

 

[Mike H..]

Thanks Narayan. I am trying to compare two points and say if no sales in year 1, but sales in yr 2, then new customer.

Hi,

Is this what you want? Have a look at the workbook.

 

[ittiams]

I am trying to build a formula to come up with a count or sumif.
If a customer has no sales in 2011, but has sales in 2012 - then it is a new customer. I want to build a column with a count then sum it up to get a count.

I tried the difference of year 2 and year 1 to find out if greater than zero and equal to year 2 value. then if both values were zero - it would throw up a new customer.

Please help.

Hi,

Is this what you want? Have a look at the workbook.

Hi Mike.. exact solution I was looking for - this is VERY helpful and an excel learning for me. Thank you very much.