Sumif I Think

Giganews Newsgroups
Subject: Sumif I Think
Posted by:  Paul (Msr…
Date: Fri, 25 Jul 2008

D  E  G  I

p  s  $2  $2
q  t  $2  $2
p  s  $2
r  y  $2
s  z  $2  $2
p  t  $2  $2

I have the following formula in a table which gathers data from the
example above..


The problem is that in column I sometimes there isn't a dollar amount,
so the formula I have multiplies $2 x 0 and comes up with Zero.

Ex: I want to know the total dollar amounts for Items P that
correspond with Items S...answer should be $6