Sum If Array Formula Question

I’m trying to use an array formula with sumif and know the correct format is along the lines of =sum(sumif(A:A,B:B,{“hello”,”hi”})), 

 

However when I try to use > or < than operators, the formula doesn’t work. eg. =SUM(SUMIFS($T:$T,$M:$M,{“>”&2,”<“&10000})). Can someone please help me with how this formula would work? Thank you and I’d really appreciate it.

By: Shahbaz Nayyar

Leave a Reply

Your email address will not be published. Required fields are marked *