Curtis Long
asked on
sumifs excel 2013
I have a basic spread sheet. I have attached a sample.
I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 1-1-2017 and 1-31-2017
I cant quite seem to get it nailed done.
Can you help??
Thanks!!
experts.xlsx
I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 1-1-2017 and 1-31-2017
I cant quite seem to get it nailed done.
Can you help??
Thanks!!
experts.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
test this
=SUMIFS(C2:C9,B2:B9,"=*Swings",A2:A9,">=1/1/2017", A2:A9,"<=1/31/2017")
ASKER