[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Help with Sumif Excel Formula

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
0
Matt Pinkston
Asked:
Matt Pinkston
  • 4
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try with XL 2007 or higher

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


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


John
0
 
Steven HarrisPresidentCommented:
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...)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rgonzo1971Commented:
whitout XL 2007 or higher

pls use

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

Regards
0
 
Rgonzo1971Commented:
Hi,

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

Many thanks
0
 
Steven HarrisPresidentCommented:
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.
0
 
Rgonzo1971Commented:
@ Harris
It is not for the points I just what to know what I've overlooked ( if anything)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now