I'm trying to write a sum function for all entries in a certain month (>= start of month, < eomonth + 1) where a certain field has one of several values.
(For example: All entries in July, where project = Project A or project = Project B)
So far, I've been using
SUMIFS, but I can't figure out how to get the
OR criterion in.
SUMIFS(E:E, C:C, ">="&B6, C:C, "<"&EOMONTH(B6, 0)+1, G:G, "=Project A“, A:A, "=Person B”)
The B column holds a particular month as a date. I'd like to use the
OR criterion on people (e.g.
"=Person B" OR "=Person C").