 |
| |
| Data on data revenue COUNTIFPosted: 22 Feb 2012 Tags: Data on data revenue COUNTIF Data data revenue COUNTIF  Source: openoffice.blogs.com Question: I try to earn income from paid accounts vs. not paid in a single SS. How I get this answer is I am using = CountIf(D2:D25,"paid") which gives me the number of paid accounts. Say 10 25 accounts have been paid. I have a cell that shows this part Accounts Paid2Accounts Owe96Accounts Late0 with that information I want to get a sum of these accounts payable payment cell. Monthly payment student DateMarch1 $ 80.00 $6thPaid2 85.00 15thNot paid I want a cell to show that I had an income of $80.00 for the paid account and if the student 2 countries and the cell is modified to paid I try to get the cell back to change the $80.00 165.00. I just want to know what has been done of cells B2: B25 if the cells in the range d say paid. Is it possible? I used the Pivot that does this, but it does not change to be followed at the least that i can find a way. If change a cell not paid, I want that it also changes the income. Answer: You can use SUMIF: = SUMIF (D2: D25, "paid", B2: B25) Rate this article:
|
Home
Add Your Article
Categories
Search Something
Latest Buzz
Related Buzz
0 Comments