I bet you meant ctrl-shift-enter (not Ctrl+Shift+Del).



Ashish Mathur wrote:

Hi,

While sumproduct is the most effective way of solving this problem, another
way of achieving the same result is by using an array formula (Ctrl+Shift+Del)

=sum(if((rangeA="Wichita")*(rangeB="Kansas"),range C))

Regards,

Ashish Mathur

"Slax" wrote:

Column A is Cities, Column B is States. Column C is Dollars. There
are 200 rows of information. I want to add the values in Column C if
the City is Wichita and the State is Kansas. Can sumif do this??



--

Dave Peterson