Sumif does not work


Joined
Aug 19, 2016
Messages
29
Reaction score
1
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
 
Joined
Feb 2, 2016
Messages
25
Reaction score
9
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)
 
Joined
Dec 28, 2017
Messages
8
Reaction score
1
Just change "." To ":"
SUMIF($B$2:$B$12,"Cash",$C$2:$C$12)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top