Calculate Values based on criteria in the columns

Hi,
I have attached a spreadsheet that details the amounts I owe to vendors. My accounting program spits out the Data till Column I ( Foreign amount). I then calculate Col J for exchange rate. This column gets populated only if the Foreign amount column value is not the same as amount in Column F).
What I need is specified in the sheet along with comments. ( Cell o4, N3, M4)

Wow! You must have joined the forum soon after it started.

Try these in the following cells:

M4: =SUMIFS(I:I,J:J,">1")

N3: =SUMIFS(I:I,J:J,"")

O4: =SUMIFS(F:F,J:J,"<>?*",D:D,"<>")

Hope this helps.

Pete

Thanks Pete. It worked!

Hi Pete,
I dont think cell O4 is calculating properly. It gives the total amount for row that has no exchange rate in it as well. It should only pick up the total of "Amounts Column" where there is an exchange rate. Could you please look into it?

Hi Pete,
I have fixed the issue. Thanks again for your help!

You can also show your appreciation and directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete