SUMIFS Multiple Criteria - Same Column

[neodjandre]

I am using this formula

SUMIFS(BankFeed1[Calc],BankFeed1[Date],">=" &v_start,BankFeed1[Date],"<=" &v_end,BankFeed1[Cstat],{name1,name2})

But only name1 gets summed up. I thought by using curly brackets, I could sum up two criteria in same column.

 

[Marcelo Branco]

ok it works as I hadn't changed to SUMPRODUCT

Glad it worked for you

M.