help in excel

Hi
if col A is customer card number and col B is amount of peso spent, In col C insert the formula
=if(countif(A1:A25,A1)>=3, sumif(A1:A25,A1,B1:B25)/50, "")
For customer in A1 if he had 3 or more transactions, then it will total their amount and divides by 50 to give the number of points earned. drag the formula till the end of data.
Ravi

sir, thank you very much, but the complicated thing is that i had a table with date and each point is tabulated to a particular date that they visited or used the card. My col A is the card number and col B to AE are the dates with points earned how will i calculate the points earned after three transactions for each card. I will be very glad if you can help me as soon as possible, thank you very much.

You have not givin us enough information. In which Cols do the Points reside. If I assume that Col B has a date and Col C has the points for that date and Col D has a date and Col E has the points ect... You could add all the points in Col AG by typing an = then clicking in Cell C1 then type + then click in cell E1 then type +... continue till have included all the cells in that row with point values. That will give you the total points for the card. Copy the formula down.
If this isn't what you were looking for then give us some more specifics.

Salamat Po

Here is my interpretation about the question
http://www.esnips.com/doc/fce2b50a-297a-47fd-9b79-91ab86fb8cd2/TERCETOS

GALILEOGALI