Formulas...CountIfs I believe

clifka · 03/07/18

In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome.

I have two columns. Both are drop downs.

Column Program: A, B, C

Column Status: A, B, C, D, E

Would like to create a formula that will count how many A's are in Program column WHEN Status column is b, c, or d

All formulas I am creating give me error messages? Any help would be appreciated. Thank You.

Tukee · 03/07/18

This works for me.

=IF(Status3 <> "A", IF(Status3 <> "E", COUNTIF(Program3, "A")))

See image. I think it follows the logic you're looking for.

clifka · 03/07/18

Thank You Tukee.

Unfortunately, this isn't working for me. I will keep trying.

Tukee · 03/07/18

Not what you were looking for? Or do you just get the unparsable error or similar error? Load some screen shots I'll see if I can help you figure it out.

clifka · 03/08/18

I receive #invalid Data type and #invalid operation. I have attached a couple of the formulas I have tried related to what you sent. Here is a better snapshot of what I am trying to accomplish:

I am attempting to create a formula which references another sheet

One column called Program with drop down options of Service Expansion, Frontline Fast, Readyline Express.

Another column called Status with drop down options of Qualifying, Initial Meeting/Needs Analysis, Proposal, Negotiation, Closed Won, Not Interested, Doesn’t

I am trying to create a formula, in a separate worksheet, that will count all the ‘Service Expansions’ in the program column WHEN the Status is “Qualifying, Initial Meeting/Needs Analysis, Proposal, or Negotiation”.

Formula IF Countif.png