What am I doing wrong with my =sumif ?
 

I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include the
criteria "blank". Am I using the right function? If so, where have I gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)

What am I doing wrong with my =sumif ?
 

Try

=SUMIF(B1:B5,"J",A1:A5)

"Idunno Yet" wrote:

I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include the
criteria "blank". Am I using the right function? If so, where have I gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)

What am I doing wrong with my =sumif ?
 

=SUMIF(B1:B5,"J,"A1:A5)

J is text so needs be placed in double quotes as shown

If you want to include blank (empty) to could use:

=SUMIF(B1:B5,"J",A1:A5)+SUMIF(B1:B5,"",A1:A5)


HTH


"Idunno Yet" wrote:

I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include the
criteria "blank". Am I using the right function? If so, where have I gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)

What am I doing wrong with my =sumif ?
 

=SUMIF(B:B,"J",A:A)+SUMIF(B:B,"",A:A)
or B1:B5 and A1:A5

--
Greetings from New Zealand
"Idunno Yet" wrote in message
...
I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include
the
criteria "blank". Am I using the right function? If so, where have I
gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)

What am I doing wrong with my =sumif ?
 

To make your orijnial formula work enclose the *J* in quotes:

=SUMIF(B1:B7,"J",A1:A7)

To add a test for blank cells use:
=SUMPRODUCT(((B1:B7="J")+(B1:B7=""))*A1:A7)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Idunno Yet" wrote in message
...
I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include
the
criteria "blank". Am I using the right function? If so, where have I
gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)

What am I doing wrong with my =sumif ?
 

Another way:

=SUM(SUMIF(B1:B5,{"J",""},A1:A5))


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Idunno Yet" wrote in message
...
I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include
the
criteria "blank". Am I using the right function? If so, where have I
gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)