Home/ Questions/Q 2298
Next
Answered
computing
  • 0
Asked: 2021-10-28T00:44:01+00:00 In:

Sum If Is Double Counting

  • 0

Hi

I have never come across this before and cannot work it out.

I have a range of data:
A B C D
Category Oct-10 Nov-10 Dec-10
1 Production 10 10 10
2 Selling 2 2 2
3 Markeeting 1 1 1

When I do a sumif as follows =sumif($a$1:$d$3,$a1,B;B) so that the range is absolute, the criteria is always from column a and the sum column moves across one each time I am getting a double count. Eg Marketing is returning a value of 2 where I think should be 1.

If I delete the values in column C the calculation returns 1.

Any ideas?

Thanks in advance.

Nick

Share

    1 Answer

    1. Best Answer
      I’m not sure how your data is set up, but on first glance your formula has an error:

      B;B <semi-colon

      should be

      B:B <colon

      If your data is:

                 A     B       C       D
1) Production	10	10	10
2) Selling	 2	 2	 2
3) Markeeting	 1	 1	 1

      Then your formula, =SUMIF($A$1:$D$3,$A1,B:B) with the corrected B:B returns 10, as expected.

      MIKE

      http://www.skeptic.com/

      • 0