sumif multiple criteria

Karrie Davis

Hi,

I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist

=SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget")

Thanks

Nick Burrus

In a SUMIFs the first reference needs to be what you're trying to "sum"

 

=SUMIFS([Sum], critera 1, answer, critera 2, answer)

Nick - Smartsheet Product Certified

Karrie Davis

Thank you Nick,

 

The first reference is what I'm trying the to sum. The current weeks capacity, but I want to add a second criteria that sum if it is a specific work type. This is where I'm having the problem. Could you please assist. 

 

Thank you

Karrie Davis

This is the formula I came up with, however I sill can't seem to get it to work. 

=SUMIFS({Capacity}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Caitlin status}, "In Progress")

Karrie Davis

Thanks I figured it out

Andrée Starå

Excellent!

Glad you got it working!