COUNIFS returning #VALUE!

New Contributor

Hi was wondering if someone could help.


I am trying to use COUNTIFS to tell how many tickets with specific priority are in a certain status within a certain sprint.


Tab name is Data In

Priority is in A:A

Status is in B:B

Sprint is in C:I (Multiple Columns) value only in once within range


The formula I am using is: =COUNTIFS('Data In'!C:I,"SysOps_2022Apr08",'Data In'!B:B,"On Hold", 'Data In'!A:A,"Critical")


However this keep returning #VALUE!. When I split each component separately they all work, but together fails.



2 Replies
best response confirmed by Russtuff (New Contributor)


=SUMPRODUCT(('Data In'!C:I="SysOps_2022Apr08")*('Data In'!B:B="On Hold")*('Data In'!A:A="Critical"))

Is this what you are looking for?

Amazing thank you