• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with sumif formula

Hello,

I have an excel sheet where expenses for internal divisions are tracked by their fund number, by GL, and by month. I have a file of raw data where all the division expenses are shown. I have one tab each set up for the individual divisions and trying to pull the information for that division from the raw data.

The formula is tried to use was this
=SUMIFS(tamt,gla,$A4,fnumber,$I$2,podate,">="&I$3,podate,"<"&J$3)
But this just gives me zeros and not pulling any of the real information.

What am I doing wrong? Thank you in advance
 

Attachments

Hello,

I have an excel sheet where expenses for internal divisions are tracked by their fund number, by GL, and by month. I have a file of raw data where all the division expenses are shown. I have one tab each set up for the individual divisions and trying to pull the information for that division from the raw data.

The formula is tried to use was this
=SUMIFS(tamt,gla,$A4,fnumber,$I$2,podate,">="&I$3,podate,"<"&J$3)
But this just gives me zeros and not pulling any of the real information.

What am I doing wrong? Thank you in advance

Please see attached
 

Attachments

Hello,

I have an excel sheet where expenses for internal divisions are tracked by their fund number, by GL, and by month. I have a file of raw data where all the division expenses are shown. I have one tab each set up for the individual divisions and trying to pull the information for that division from the raw data.

The formula is tried to use was this
=SUMIFS(tamt,gla,$A4,fnumber,$I$2,podate,">="&I$3,podate,"<"&J$3)
But this just gives me zeros and not pulling any of the real information.

What am I doing wrong? Thank you in advance

Please see attached. Had to make a change
 

Attachments

Top