Hi,

I have a question that I’m sure someone out there can answer.

The following formula has worked great, but I need to evolve it: =SUMIFS(‘List of Transactions’!G3:G373,’List of Transactions’!K3:K373,”R”,’List of Transactions’!G3:G373,”>”&0)

Here’s what I need the formula to do, with the functionality I need to add in bold:

Sum the values in Column G IF
Column K is ROR Column I is RAnd the value in Column G is > O

Thanks in advance for your help!

​Hi,I have a question that I’m sure someone out there can answer. The following formula has worked great, but I need to evolve it: =SUMIFS(‘List of Transactions’!G3:G373,’List of Transactions’!K3:K373,”R”,’List of Transactions’!G3:G373,”>”&0) Here’s what I need the formula to do, with the functionality I need to add in bold:Sum the values in Column G IFColumn K is ROR Column I is RAnd the value in Column G is > OThanks in advance for your help!   Read More

​