I am trying to SUM $R$4:$R$44959 where the value is >0 and the value in $A44963 is found in $A$4:$A$44959. I've done the work manually for a the value in A44963 and A44964 so I know what the result should be.
Here's what I have but I get a "too few arguments" error.
=SUMIFS($R$4:$R$44959,">0",A44963,$A$4:$A$44959)
Thanks in advance.
Here's what I have but I get a "too few arguments" error.
=SUMIFS($R$4:$R$44959,">0",A44963,$A$4:$A$44959)
Thanks in advance.