Sum of cells based upon text in next cell

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
try
=SUMIF(C:C,"DAD",B:B)
-----Original Message-----
I want to SUM currency in column B based upon the text in
Click to expand...
column C (same row) into cell G1. To say another way,
where the text word 'DAD' appears in column C, take the
number in column B and sum it into cell G1. And there
will be mulitple entries of DAD and six other people as
well. Can someone help please?
 
Hi

Another option:
=SUMPRODUCT(--(C2:C1000="DAD"),--(B2:B1000))

--
Andy.


tkwoodruff6 said:
OOPS! Works great with Excel, but not with Quicksheet for Palm. IFSUM is
Click to expand...
not part of Quicksheet formulas. Any ideas?
 
Back
Top