help in excel

[engrdcatinhere]

I have a project or needs a report to calculate and it goes something like this, i have to calculate the total amount of points earned by a customer when using a rewards card. this is used (card) to earn/accumulate points, for every 50.00 pesos is equivalent to one point. I have to calculate the total points earned for each activated cards after three transactions, i have thousands of activated cards. not sure how will i calculate these given data....... hope to hear from someone soon...thank you!!!!

 

[ravishankar]

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

 

[engrdcatinhere]

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.

 

[Traveler]

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

 

[galileogali]

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

GALILEOGALI