SUMIFS help

[RodneyC]

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.

 

[Fluff]

With sumifs the arguments are range to sum, 1st criteria range, 1st criteria, 2nd criteria range, 2nd criteria etc.
You don't have a sum range & the 2nd & 3rd arguments are in the wrong order.

 

[Joe4]

See here for a detailed breakdown of the function and examples:

MS Excel: How to use the SUMIFS Function (WS)

This Excel tutorial explains how to use the Excel SUMIFS function with syntax and examples. The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on a single or multiple criteria.

www.techonthenet.com

Note that you can find articles like this on the internet for ALL Excel functions.
It is a great resource if you do not know how to use a function, or are having issues getting it to work properly.