# Thread: Sumif not adding values correcly

1. ## Sumif not adding values correcly

I have values in Columns B to D and ageing of the data in Col E

I have tried to set up a SUMIF formulas to compute the following

1) The value of the data in Columns B to D where the ageing is 7 days or less
2) The value of the data in Columns B to D where the ageing is greater than 7 days

My formula only gives the total of the values in Col B

=SUMIF(E5:E46,"<=7",B5 to D46) B646 does not show in formula on post

=SUMIF(E5:E46,">7",B5 to D46)

If sumif can't be used, please advise how I can use Sumproduct to do this for me

Your assistance will be most appreciated

2. Hi Howard

Posting a sample file would make it easier.

zeddy

3. Hi Zeddy

Attached please find file as requested

Regards

Howard

4. Howard,

This works:
=SUMIF(E5:E34,">7",B5:B34)+SUMIF(E5:E34,">7",C5:C3 4)+SUMIF(E5:E34,">7",D5:D34)

As you have it, it is only summing col B. HTH

5. I think you need to use a matrix or table function. I have never been able to use those except for 1 column at a time.

6. Thanks for the help, much appreciated. Would sumproduct not be easier to use in this instance and if so how do I use this formula?

7. =sumproduct((e5:e46<=7)*b5: D46)

8. Hi Howard

Why not simplify it as per attached file?

I changed some Ageing values in rows 5 to 12 to show some results in rows 44 and 46
(Original sample values are copied in column [H] )

zeddy

9. ## The Following User Says Thank You to zeddy For This Useful Post:

HowardC (2013-04-09)

10. Hi Zeddy

Thanks for the help

Good idea to simply and show ageing per category i.e new used wholesale

With regard ro the sumproduct, I had the formula almost correct i.e =SUMPRODUCT(E5:E34>7)*B534. This returned # Value

Regards

Howard

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•