Calculate the results of a formula in different cells

[JEA1179]

Hi All,

What I'm trying to do, is calculate the different invoice amounts, based on account codes, into different cells. For example; Column F is the invoice amounts. Column H is the account codes. If the invoice amounts in F4:F50 match Account 5 then enter this into J4. If the invoice amounts in F4:F50 match Account 6, then enter this amount into J5.

What I tried in cell J4 was: =IF(isnumber(Match(5,Sum(F4:F50,0))) No Luck with that

Then I tried in Cell J4: =IF(H4:H50=5,Sum(F4:F50),"") That worked but it didn't matter if it was account code 5 or not, it continued to calculate F4:F50, just like I asked it to do. I'm sure there is a way to do this but with my limited excel knowledge, I can't figure it out.

Thank you for any help

[oeldere]

You get better help on your question if your follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

[Speshul]

Not sure I 100% follow, but something like this?

=sumif(F4:F50,5,H4:H50)

[JEA1179]

My apologies...I thought I had explained it pretty well...I'd have to agree with you,it would be easier to see what I'm trying to accomplish as opposed to reading what I want to do

[ben_hensel]

Then I tried in Cell J4: =IF(H4:H50=5,Sum(F4:F50),"") That worked but it didn't matter if it was account code 5 or not, it continued to calculate F4:F50, just like I asked it to do. I'm sure there is a way to do this but with my limited excel knowledge, I can't figure it out.

As an array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER),

Please Login or Register  to view this content.

So you need to nest the IF inside the SUM, not the other way around.

...of course, instead of that, I think a SUMIF like speshul suggested is better.

[JEA1179]

Speshul and ben_hensel Thanks for the help...