Formulas...CountIfs I believe

clifka

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.

Find more posts tagged with

Formulas

Comments

Tukee

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

Thank You Tukee.

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

Tukee

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

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

Formula IF Countif B.png

Formula IF Countif C.png

clifka

Hi Tukee!

Wanted to let you know that this has been resolved. Thank you for your help along the way.

Have a GREAT day.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…