help with a countifs statement

**djayk85** · 11-19-2018, 08:12 AM

I have the following formula in a Spreadsheet I am using:

=COUNTIFS('Incidents & Questions'!$A:$A,">="&'Incident Overview'!$E11,'Incidents & Questions'!$A:$A,"<"&'Incident Overview'!$E12,'Incidents & Questions'!$B:$B,'Incident Overview'!I$3,'Incidents & Questions'!$C:$C,"INCIDENT")

I didn't write this formula, however I need to amend it due to added variables in the source data and include another count in the selection in addition to "INCIDENT".

How do I amend the formula to add in the variable "Q UPGRADED TO I" so that the output counts and totals both INCIDENT and Q UPGRADED TO I?

**Glenn Kennedy** · 11-19-2018, 08:16 AM

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

**djayk85** · 11-19-2018, 08:25 AM

Thanks for the reply. Due to the sensitive nature of the data and spreadsheet I am unable to upload an example of it as amending all the sensitive data fields would break the spreadsheet due to the other formatting that is present.

**63falcondude** · 11-19-2018, 08:34 AM

Try

=SUM(COUNTIFS('Incidents & Questions'!$A:$A,">="&'Incident Overview'!$E11,'Incidents & Questions'!$A:$A,"<"&'Incident Overview'!$E12,'Incidents & Questions'!$B:$B,'Incident Overview'!I$3,'Incidents & Questions'!$C:$C,{"INCIDENT","Q UPGRADED TO I"})

**djayk85** · 11-19-2018, 08:56 AM

Originally Posted by 63falcondude

Try

=SUM(COUNTIFS('Incidents & Questions'!$A:$A,">="&'Incident Overview'!$E11,'Incidents & Questions'!$A:$A,"<"&'Incident Overview'!$E12,'Incidents & Questions'!$B:$B,'Incident Overview'!I$3,'Incidents & Questions'!$C:$C,{"INCIDENT","Q UPGRADED TO I"})

That worked perfectly, thanks

**63falcondude** · 11-19-2018, 08:59 AM

You're welcome. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

help with a countifs statement

LinkBack

Thread Tools

Rate This Thread

Display

help with a countifs statement

Re: help with a countifs statement

Re: help with a countifs statement

Re: help with a countifs statement

Re: help with a countifs statement

Re: help with a countifs statement

Thread Information

Users Browsing this Thread

Similar Threads

countifs and or statement

[SOLVED] if statement with countifs statement with two variables

[SOLVED] Countifs statement help

Or within Countifs statement

[SOLVED] help nesting OR statement into COUNTIFS statement

[SOLVED] =COUNTIFS statement

Countifs Statement

Bookmarks

Bookmarks

Posting Permissions