Multiple criteria on sum fuction not working

[theLEARNER1991]

Hello friends,
The sheet which I have created has got following columns for data entry.
column a date
column b particulars
column c amount
column c category (5 categories in drop down menu are are income & commission, expenses, expenses reimbursed, loss, loss recovered)
column d funds allocated
cell j3 contains start of assessment date
cell k3 contains end of assessment date
in cell n3 I want to compute sum of expenses between assessment date which should exclude expenses reimbursed.
Formula which I am using is giving error, formula used in n3 is
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>=(SUMIFS(C:C,A:A,">="&J3,A:A"<="&K3,D:D="EXPENSES")-SUMIFS(C:C,A:A,">="&J3,A:A"<="&K3,D:D="EXPENSES REIMBURSED"))
I even tried to compute both expenses and expenses reimbursed in different cell but still i got error
formula used to compute expenses is =SUMIFS(C:C,A:A,">="&J3,A:A"<="&K3,D:D="EXPENSES")

Your help would be appreciated

Thanks

 

[steve the fish]

You dont use D:D="EXPENSES" you would just use D:D,"EXPENSES"

 

[theLEARNER1991]

Thanks for reply but it still resulted in an error

 

[Marcílio_Lobão]

theLEARNER1991, Good afternoon.

Try to use:

=(SUMIFS(C:C,A:A,">="&J3,A:A,"<="&K3,D:D,"EXPENSES")-SUMIFS(C:C,A:A,">="&J3,A:A,"<="&K3,D:D,"EXPENSES REIMBURSED"))

Please, tell us if it worked as desired.
I hope it helps.

 

[theLEARNER1991]

theLEARNER1991, Good afternoon.

Try to use:

=(SUMIFS(C:C,A:A,">="&J3,A:A,"<="&K3,D:D,"EXPENSES")-SUMIFS(C:C,A:A,">="&J3,A:A,"<="&K3,D:D,"EXPENSES REIMBURSED"))

Please, tell us if it worked as desired.
I hope it helps.

Thanks for replying but it still doesn't work

 

[Marcílio_Lobão]

theLEARNER1991, Good afternoon.

Whitout an example it's very hard to help you conclusively.

Try to save your file at a free site, www.sendspace.com and put a link to download here.

I hope it helps.

 

[Aladin Akyurek]

This should work...

=SUM(SUMIFS(C:C,A:A,">="&J3,A:A"<="&K3,D:D,{"EXPENSES","EXPENSES REIMBURSED"}),{1,-1})

If not, what result do you get?