Help with Sumif Excel Formula

Matt Pinkston
Matt Pinkston used Ask the Experts™
on
I have the following sumif formula I am using

=SUMIF(Data!O:O, "Civilian", Data!K:K)
 
Now I need to include another check along with the check for Civilian in O I also need to check for 2015 in J
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
Hi,

pls try with XL 2007 or higher

=SUMIFS( Data!K:K,Data!O:O,"Civilian",Data!J:J,2015)


Regards

Commented:
What version of Excel do you have/
Have you got the SUMIFS formula; allows you to enter multiple criteria.


John
President
Commented:
SUMIFS for Multiple Criteria:

SUMIFS(SumRange, CriteriaRange1, Criteria1, CriteriaRange2, Criteria2,...)

=SUMIFS(Data!K:K, Data!O:O, "Civilian", Data!J:J, "2015")

(should have refreshed as Rgonzo covered it...)
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Top Expert 2016

Commented:
whitout XL 2007 or higher

pls use

=SUMPRODUCT(Data!K:K*(Data!J:J=2015)*(Data!O:O="Civilian"))

Regards
Top Expert 2016

Commented:
Hi,

Could you explain why have you chosen the version of Steven Harris over mine?

Many thanks
Steven HarrisPresident

Commented:
Just a guess, but the addition of the explanation of SUMIFS?

Either way, I am not in a points race so these can redistributed as necessary.
Top Expert 2016

Commented:
@ Harris
It is not for the points I just what to know what I've overlooked ( if anything)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial