SUMIF function usually works, but this time...

[aherzog]

HELP with SUMIF function....

I'm trying to make a budget sheet. I want everything in the F column that says a keyword, like "food", to calculate the price I paid for that in cell D.

I have done this function before in other excel workbooks and it is fine. For some reason, it won't work on this one and I get an error message. It says the first cell is empty, or something is wrong from there?

Any ideas on why I'm getting this error message when I have similar workbooks with no issue using this format and layout?

 

[kweaver]

I think you meant column H (or I) that is "food" (and not column F)

I didn't have a problem with (placed in K column and filled down):

=SUMIF($H$5:$H$15,L5,$D$5:$D$15)

as long as column D was formatted using a custom format of: 0.00 kr;;-

 

[aherzog]

I think you meant column H (or I) that is "food" (and not column F)

I didn't have a problem with (placed in K column and filled down):

=SUMIF($H$5:$H$15,L5,$D$5:$D$15)

as long as column D was formatted using a custom format of: 0.00 kr;;-

To be clear, I forgot to mention.... column H is a replica of column I but is instead a drop down. Are you suggesting I should try to add some $ ?

 

[aherzog]

I think you meant column H (or I) that is "food" (and not column F)

Also, where is column F in this formula? Is that somehow messing things up?

 

[kweaver]

How does column F come into play here?

 

[kweaver]

If you need to sometimes pick up the values in column C, consider this ARRAY FORMULA:

=SUM(($C$5:$C$15+$D$5:$D$15)*(--($H$5:$H$15=L5)))

 

[aherzog]

If you need to sometimes pick up the values in column C, consider this ARRAY FORMULA:

=SUM(($C$5:$C$15+$D$5:$D$15)*(--($H$5:$H$15=L5)))

Good news... I got the error code to go away. However, the number still shows up as 0. I noticed one of the cells was blank so I filled it with 0 and it may the total zero though, for the whole row. The goal is to have every row which is labeled "Food" to Sum all of them and add the total from their corresponding amount in column D to the SUMIF function. Does that make sense? So then why are they showing up as 0 still?