SUMIF

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

Hi
I have a excel file that has SUMIF formulas (SUMIF(J14:J20,"Annette",
J14:J20). It works well on 2003. However, the SUMIF formulars stop working
when I open the file with 2007.


Please help
Thank you
Chi Huynh
 
The formula you have shown should not work even in Excel 2003...
It is looking for cells having Annette in J14:J20 and adding J14:J20
itself... which makes no sense since adding names does not mean anything..

Try
=SUMIF(J14:J20,"Annette", K14:K20)
after putting in numbers in K14:K20... it will add up numbers for rows
having Annette...
 
Hi Sheeloo,
Thank you so much for the information. It woks!!!. However, after changing
the numbers in K14: K 20, the formulas didn’t recalculate.

In order to see the new results, I have to close the Excel completely and
open it again. Would you please show me to fix the problem - to make the
formulas recalculate without closing Excel.

Thanks
Chi Huynh

Chi Huynh
 

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

Similar Threads

Filtering with SUMIFS 1
more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE** 3
sumproduct or sumif? 3
Sumifs formula in Excel 2007 3
Convert SUMIFS formula from 2007 to 2003 5
how can I set a fixed width font in the formula bar? 2
using excel formulas in VB coding 4
nested sumif 5

Back
Top