Formula: In ListA Then what is value in listB if none/Blank

[TRShepard]

I am trying to figure this out in a formual and any help would be nice. Thanks.

If A03:A5000 = January And BC03:BC5000 = 1 then count how many 1's there are and return that value and if there is no 1's leave blank

[Don]

Hi and welcome to the forum!

Try this function:

Code: Select all

=COUNTIFS(A3:A5000,"January",BC3:BC5000,1)

hope this helps!

[TRShepard]

Unfortunately it did not work. I had at least one January and at least one
1 however the anwser it returned was 0. Let me give an example to try to
help clarify what I am looking for from this formula


Example-1.a
------------A---------B-------C------D
------1---January---1---------------2
------2---February--1----------------
------3---January---1----------------
------4---January---0----------------
------5---March-----1----------------
Example-1.b
------------A---------B-------C------D
------1---January---0---------------0
------2---February--1----------------
------3---January---0----------------
------4---January---0----------------
------5---March-----1----------------

In the example 1.a it counts the 1's in column B that correspond
with only the January's in Column A

In the example 1.b it counts no 1's in column B because there
are no January's with 1's that correspond in Column A

[Don]

That's exactly how the function I posted is supposed to work.

What version of Excel are you using? Also, can you include a sample spreadsheet?

[TRShepard]

I reapplied the formula and I must have done something wrong the first time. It worked perfect. Thanks so much!

Tom

[TRShepard]

Let me throw another one out that is the same thing, only a little different.

Instead of adding 1's I would like to add the total sum of dollar Amts.

Example-1.a
------------A---------B-----------C------D
------1---January---1.50---------------3.00
------2---February--1.50----------------
------3---January---1.50----------------
------4---January---0.00----------------
------5---March-----1.50----------------
Example-1.b
------------A---------B-----------C------D
------1---January---0.00---------------0.00
------2---February--1.50----------------
------3---January---0.00----------------
------4---January---0.00----------------
------5---March-----1.00----------------

[TRShepard]

Ok this time I got it myself

=SUMIF(A1:A50,"January",B1:B5)

Thanks All!!