IF Statements-performing services

[glenbriar6]

I am trying to use Excel to manage customer accounts. I currently have excel set up with my customer names on the far left column, the column next to that has my price for that particular customer (each customer has different prices charged) next to that column I have a sales tax column so I can charge 8% of 1 month's worth of charges for each customer. On the next several columns I have the different dates that I am performing services, and under these columns I have inserted "X" 's in the cell's under the columns to indicate that I have completed services for them that week (some weeks I don't perform services, hence the insertion of no "X"). I then have a last column with sales charges for the month, for each customer. I started creating an IF statement in excel to say if there is an "X" in the columns under the dates, then add up the number of "X" 's and multiply that by the column with my prices, plus have the sales tax calculated in the other column based on the total charges for the month.

I have attached a sample of how I have this setup with the colums and rows, as a word document. Thank You for the help!

[mrice]

Try this user defined function on the attachment. Hit ALT F11 to see how it works.


You could also have used

=(B3+C3)*COUNTIF(D3:E3,"X")