Sumif does not work

[msnarayanan]

dear all

i have created 4 tables which contains common fields
/names such as cash, printing, donations etc.

in a particular table, i had created a drop down from a list in other table. for entering
the data there is no problem. in another column i enter amounts.

problem arises which i used the following formula it does not work:

=sumif($b$2.$b$12,"cash",$c$2.$c$12)

should i change the formula, and if so how.

please note the range/names are taken from another table.

m s narayanan

 

[Amy @ German Pearls]

The start and end of the ranges should be separated by a colon ) not a period (.). Other than that, looks good.
=sumif($b$2:$b$12,"cash",$c$2:$c$12)

 

[Luck]

Just change "." To ":"
SUMIF($B$2:$B$12,"Cash",$C$2:$C$12)