SUMIF/COUNTIF

T

Tatebana

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...
 
B

bj

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()
 
R

Ron Coderre

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
 
Top