|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#6
11-17-2016, 02:49 PM
|
|||
|
|||
A1 B1 C1 D1
25.00 0.00 CASH 72.00 32.00 0.00 CASH 00 15.00 CASH column a is one departments account column b is another departments account column c is the method of payment and I would like column d to add only cash payments but ONLY in one cell. There will be other forms of payments but I would like excel to only find cash payments. the other 2 (after editing to my actual cells) produced a zero. and I did put quotes around the CASH Thanks in advance 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
| Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
| How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
| Copying data from one cell to another where condition is third cell | fairyca | Excel | 4 | 03-30-2014 08:22 AM |
| How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Wanting to get data from one cell and and add the data from corresponding cell
Windows 10 
Office 2007
Threaded Mode