SUMIF/COUNTIF
 

The SUMIF formula works fine if as "criteria" I use a specific value.

I tried =SUMIF($A:$A,<"",$C:$C) and =SUMIF($A:$A,$C:$C)

but they do not work...

SUMIF/COUNTIF
 

What are you trying to do and maybe help can be provided?

"Tatebana" wrote:

The SUMIF formula works fine if as "criteria" I use a specific value.

I tried =SUMIF($A:$A,<"",$C:$C) and =SUMIF($A:$A,$C:$C)

but they do not work...

SUMIF/COUNTIF
 

the sumproduct() function should do what you want
=sumproduct(--(A1:A64000<""),C1:C6400)
[you cant use the A:A shorthand for full column in Sumproduct()

"Tatebana" wrote:

The SUMIF formula works fine if as "criteria" I use a specific value.

I tried =SUMIF($A:$A,<"",$C:$C) and =SUMIF($A:$A,$C:$C)

but they do not work...

SUMIF/COUNTIF
 

If you want to add elements of Col_C where corresponding cells in Col_A are
NOT blank then your syntax is a bit off.

Try this:
=SUMIF($A:$A,"<"&"",$C:$C)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Tatebana" wrote:

The SUMIF formula works fine if as "criteria" I use a specific value.

I tried =SUMIF($A:$A,<"",$C:$C) and =SUMIF($A:$A,$C:$C)

but they do not work...