Matt Pinkston
asked on
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
=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
What version of Excel do you have/
Have you got the SUMIFS formula; allows you to enter multiple criteria.
John
Have you got the SUMIFS formula; allows you to enter multiple criteria.
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
whitout XL 2007 or higher
pls use
=SUMPRODUCT(Data!K:K*(Data !J:J=2015) *(Data!O:O ="Civilian "))
Regards
pls use
=SUMPRODUCT(Data!K:K*(Data
Regards
Hi,
Could you explain why have you chosen the version of Steven Harris over mine?
Many thanks
Could you explain why have you chosen the version of Steven Harris over mine?
Many thanks
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.
Either way, I am not in a points race so these can redistributed as necessary.
@ Harris
It is not for the points I just what to know what I've overlooked ( if anything)
It is not for the points I just what to know what I've overlooked ( if anything)
pls try with XL 2007 or higher
=SUMIFS( Data!K:K,Data!O:O,"Civilia
Regards