If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
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! brenda
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.
View Tag Cloud
Forum Rules
Bookmarks