Embedding a SUM statment within an IF statement

[mforsberg1]

So first off I suck at excel but I am trying to get the statement only run if the G Column is equal to 71 and if its not do nothing and another formula will calculate it. So here is what I have.

Please Login or Register  to view this content.

The Sum code works before I wrap it in a IF statement I get a #Value! back I have been pasting different code together to get to this point but any help would be appreciated. I am not sure if this will even work. Also if anyone could explain if there is a better way to deal with the false statement because if it is equal to 91 its supposed to get totaled somewhere else.

[Tony Valko]

Explain in words what you want that formula to do.

[mforsberg1]

The SUM formula just totals up costs related to budget. in the F5 and down cells. So users can go in and add the costs. The IF would just check that if the cell next to the cost is a "71" fund type if its not it wont run the SUM formula

[Tony Valko]

=IF(G5:G65535=71,SUM(F5:INDEX(F5:F65536,MATCH(TRUE,INDEX(ISBLANK(F5:F65536),0,0),0)-1,0)),"91")

What is the "91" for?

[mforsberg1]

91 is the different fund type I was not sure if I had to put a value the false IF

[Jonmo1]

Try

=SUMIF(G5:G65535,71,F5:F65536)

[mforsberg1]

God that was so much easier than I was making that, it works perfectly thank you Jonmo1

[Tony Valko]

91 is the different fund type I was not sure if I had to put a value the false IF

I think you can just do this:

=SUMIF(G:G,71,F:F)

[Jonmo1]

You're welcome.

Tony's version with the entire column references would be simpler. Assuming no possible 71 entries in rows 1 through 4 (seems very likely that's the case).