sumif or sumifs
US$ 1,00,000.00 | ||||
Cash | Groceries | Home | US$ 5,000.00 | US$ 95,000.00 |
Cash | Gasoline | Auto | US$ 360.00 | US$ 94,640.00 |
Cash | Cinema | Entertainment | US$ 375.00 | US$ 94,265.00 |
Cash | Flowers | Gifts | US$ 180.00 | US$ 94,085.00 |
Credit Card | Internet | Mob and Net | US$ 1,500.00 | US$ 92,585.00 |
Credit Card | Clothes | Mob and Net | US$ 500.00 | US$ 92,085.00 |
Credit Card | Movie Rentals | Mob and Net | US$ 100.00 | US$ 91,985.00 |
Debit Card | Pro Shop | Golf | US$ 200.00 | US$ 91,785.00 |
Debit Card | Restaurant | Food | US$ 400.00 | US$ 91,385.00 |
Cheque | Groceries | Home | US$ 750.00 | US$ 90,635.00 |
Cheque | Subsciption | Home | US$ 1,500.00 | US$ 89,135.00 |
Cash | Equipment | Golf | US$ 120.00 | US$ 89,015.00 |
| ||||
Income and Expenses | January | |||
Cash Expenses | ||||
Credit Card Expenses | ||||
Cheque Expenses | ||||
Debit Card expenses | ||||
Savings |
In the cells below (marked red ) which formula adds up data from the first column(A) and the fourth (D) ie to say Cash Expenses cell is to show = sumif Column A is Cash then add up all cash expenditure in Column D, and display?
Regards
Singh
(PS the auto format in new Numbers 13 just does not accept columns designated and jumps to its own Rows / Columns)
iMac, OS X Mountain Lion (10.8.3)