Help with countif formula

CAS

Hi guys,

i want to count the results on a status column that correspond with entries that are M0 , M1, M2 , M3 , M4 ,M5

and i only want to count them if another column called Wave has a entry of Wave 1

can any one help with this formula please?

AmandaWebb

My initial thoughts without being able to see the entire data set, would be to utilize a helper sheet to count the data and sum it.

So put your data points into the first column, reference the appropriate range in your formula, then for the second reference you would select the Wave column as your data range 2 and enter "wave 1" as the other item searched for.

This should count each row that has both M0 and Wave 1, and then you can sum the total at the bottom if needed.

example:

CAS

Hi Amanda thanks for your reply. I've tried that with the formula but it returns UNPARSABLE?

This is the formula I've entered. It references another sheet as i setup a roll up sheet like you suggested.

=COUNTIFS({[BENE] Self Delivery Tracker Range 2} $[Primary Column]21, {{[BENE] Self Delivery Tracker Range 4}, "Wave 1"))

=Chris Palmer

Hello @CAS,
It appears your formula is missing a comma between the first range and criteria, and a {{ which causes a syntax error. In most cases it's good practice to use $[Primary Column]@row rather than @21 this ensures your formula is tagging the appropriate cell.

To follow suit with @AmandaWebb's formula, this might work.
And if it doesn't I would want to confirm if the brackets and [BENE] is absolutely needed in your references.

=COUNTIFS({[BENE] Self Delivery Tracker Range 2}, $[Primary Column]@row, {[BENE] Self Delivery Tracker Range 4}, "Wave 1")