# Help with an excel formula

I have the following excel SUMIFS which works well but now I also need to add to the sum column H When Q = Civilian OR column Z contains SOLD

=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*")
###### Who is Participating?

Commented:
then try
``````=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*")+SUMIFS(Report!H:H,Report!Z:Z,"*Sold*",Report!S:S,"06*")-SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!Z:Z,"*Sold*",Report!S:S,"06*")
``````
0

Commented:
Hi,
pls try

``````=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!Z:Z,"Sold")
``````
or
``````=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*",Report!Z:Z,"Sold")
``````
REgards
0

Author Commented:
I made a mistake in the original question it needs to be OR and not AND question was edited
0

Commented:
then try
``````=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*")+SUMIFS(Report!H:H,,Report!Z:Z,"Sold"Report!S:S,"06*")-SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!Z:Z,"Sold",Report!S:S,"06*")
``````
0

Author Commented:
tried this but did not work
=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*"),SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"05*",Report!Z:Z,"Sold")
0

Author Commented:
=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*")+SUMIFS(Report!H:H,,Report!Z:Z,"Sold"Report!S:S,"06*")-SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!Z:Z,"Sold",Report!S:S,"06*")

this one got an error pointing to ,"Sold"Report
0

Commented:
Corrected
``````=SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!S:S,"06*")+SUMIFS(Report!H:H,Report!Z:Z,"Sold",Report!S:S,"06*")-SUMIFS(Report!H:H,Report!Q:Q,"Civilian",Report!Z:Z,"Sold",Report!S:S,"06*")
``````
0

Author Commented:
I tested the solution but not sure it works...

the requirements was

contains SOLD isn't the formula set for = SOLD
0

Author Commented:
Awesome
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.