Results 1 to 2 of 2

Thread: simple SUMIF function not working?

  1. #1

    simple SUMIF function not working?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Here's what I want to do: SUMIF(A:A,"400-500-01",H:H)

    column A is formatted as general text
    column H is formatted as currency.

    What is it not adding? See attached..

    thanks!
    brendaClick image for larger version. 

Name:	Screen Shot 2014-09-18 at 4.56.21 PM.png 
Views:	30 
Size:	22.7 KB 
ID:	2670Click image for larger version. 

Name:	Screen Shot 2014-09-18 at 4.56.21 PM.png 
Views:	30 
Size:	22.7 KB 
ID:	2670

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Hi Brenda,
    Formula is correct. My guess is there are spaces or or other non printed characters in column A. Try in a new column = Trim(A2) and see if that helps. Otherwise I would check for text and other strange items in col H.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •