IF statement (Countifs vs. Sumifs)

[afv123]

I'm trying to use both a countifs and sumifs statement. The Countifs formula is working for me, but when I change the countifs to sumifs, it says I've entered too few arguments for the function.

My formulas are:

Countifs: +COUNTIFS('SHEET1'K:K,Summary!B1,'Detail'!V:V,">0") - this is working

Sumifs: +SUMFS('SHEET1'K:K,Summary!B1,'Detail'!V:V,">0") - this is not working, "too few arguments for the function"

 

[Fluff]

You have not includes the range to be summed. Which column should it be?

 

[afv123]

I want to sum the V Column

 

[afv123]

I've got it, thank you!

 

[Fluff]

Glad you sorted it & thanks for letting us know.