SUMIFS formula

**jsharpe995** · 11-16-2011, 10:42 AM

Hi there, I could seriously use a hand because I am certain my SUMIFS formula is correct, but obviously it isn't because I'm getting a return sum amount of 0, when it should be at least a few hundred. Any assistance would be greatly appreciated!

Background: I have a table linked to Access pulling in data into one worksheet called 'Flat Table'. I want to sum the totals in AB based on whether or not the column AG in the corresponding row contains "Basem" and the date in D is between the dates as indicated in the formula. Using the same formula as a COUNTIFS without the 'Flat Table'!AB:AB works, but of course, that's a different data set than I need. Please help!

=SUMIFS('Flat Table'!AB:AB, 'Flat Table'!AG:AG, "*Basem*", 'Flat Table'!D:D,">="&DATE(2009,7,1), 'Flat Table'!D:D,"<="&DATE(2010,6,30))

**GeneralDisarray** · 11-16-2011, 11:00 AM

can you post an example sheet? that formula works fine for me, must be something with your table your not noticing.

**NBVC** · 11-16-2011, 11:00 AM

That probably means that AB is really text strings that look like numbers.

Select column AB and go to Data|Text to Columns and just click Finish.

That should fix it...

Then format column AB as General or Number to maintain the proper format.

**jsharpe995** · 11-16-2011, 12:23 PM

That was the answer - I thought something must be awry with the data set. Thank you!

**NBVC** · 11-16-2011, 12:26 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save