Multiple Columns adding

**MRozell** · 08-20-2014, 10:38 AM

Trying to add the amount from two cell and having trouble only gives me the sum of the first one.

Column P is Current Payments that has a Formula of =SUMIF($A$3:$A$121,"="&J10,$D$3:$D$121)

What it does is look for the data that is in Column I and match it up with the data in Column A and input the data in Column D the Debit.

If it does not find a match it returns 0.00 (side? is there a way to make it return nothing, leaving the cell blank)

Column Q is Paid in Cash no Formula manually input.

Now on another sheet Paid
I would like the SUM of both Column P & Q
Currently have the following Formula
=SUMIF(Jan!$J$2:$J$26,Paid!A3,Jan!$P$2:$Q$26)

and it only gives me the value of Column P even if P is 0.00 & Q has a value like 40.00

**GeneralDisarray** · 08-20-2014, 10:40 AM

can you post an example please?

**MRozell** · 08-20-2014, 11:11 AM

Ok I will try to explain this easier

Sheet "Jan"
___A____D_____________J____P_______Q
___Code_Debit_________Code_Payment_Cash
18_B01__505.00______2__B01__505.00
33_B05___11.99______6__B05___11.99
___________________10__B09____0.00_40.00

Sheet "Paid"
___A____C
___Code_Jan
3__B01__505.00
7__B05___11.99
11_B09____0.00_(Should be 40.00)

Best I can Do since I don't know how to work the Table inset.

**GeneralDisarray** · 08-20-2014, 11:23 AM

Reply to the thread, click "Go Advanced" and then scroll down to "Manage Attachments"

Press that button, which will open a new window. Click "Add Files", then "Select Files".

That will allow you to browse for an example file. After you have selected the file, press "Upload File" and then press Done.

**MRozell** · 08-20-2014, 02:43 PM

OK if I did this right the file should upload.

In Sheets Jan - Dec: Column P is Current Payments that has the Formula of

=SUMIF($A$3:$A$121,"="&J10,$D$3:$D$121)

What it does is look for the data that is in Column I and match it up with the data in Column A and input the data in Column D the Debit.
If it does not find a match it returns 0.00 (side? is there a way to make it return nothing, leaving the cell blank)
Column Q is Paid in Cash no Formula manually input.

Now on another sheet Paid
I would like the SUM of both Column P & Q
Currently have the following Formula

=SUMIF(Jan!$J$2:$J$26,Paid!A3,Jan!$P$2:$Q$26)

and it only gives me the value of Column P even if P is 0.00 & Q has a value like 40.00

Hope this helps