I have a column with years (2013, 2014, 2015) in column D2 and a list of words (Public, Employee) in column F2.
I then have sums of money in column Q2.
I wish to look for a specific year and word and only sum the values from Q which match that criteria, thus ignoring all other values.
Last edited by nathanexcelhelp; 07-27-2016 at 10:47 AM.
Like this...
A1 = 2014
B1 = Employee
=SUMIFS(Q:Q,D:D,A1,F:F,B1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try the sumifs formula. =SUMIFS(Q:Q,criteria range 1, criteria 1, criteria range 2, criteria 2) if you want two added together you can use them back to back like =sumifs(formula1)+sumifs(formula2) if for instance you wanted both public and employee.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
sumifs formula
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
Im still struggling
Its the formulas to get the values in red im struggling with
Add up various values.jpg
Was thinking something along the lines of
=SUMIFS(Q2:Q10,D2:D10,"2014", AND F2:F10,"Public")
You have hidden columns so the formula can not be easily drag copied!
Entered in F16:
=SUMIFS($Q$2:$Q$10,$D$2:$D$10,$D16,$F$2:$F$10,F$15)
Copy down to F17
Entered in Q16:
=SUMIFS($Q$2:$Q$10,$D$2:$D$10,$D16,$F$2:$F$10,Q$15)
Copy down to Q17
That works great. Thanks Tony
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks