Thread: [Solved] Wanting to get data from one cell and and add the data from corresponding cell
View Single Post
 
Old 11-17-2016, 02:49 PM
riothecat riothecat is offline Windows 10 Office 2007
Novice
  
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default
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
Reply With Quote