Counting different cells in one formula

[rayted]

Hi guys,

I am trying to use this countif function:

=COUNTIF('Sheet1'!I2:I39, "On hold")

I want to know how I can count various cells in the same formula?

i.e.

Sheet 1, 'on hold' crtieria count cells: I2:I39 and I41:I43

Thank you

[davsth]

=COUNTIF('Sheet1'!I2:I39, "On hold")+COUNTIF('Sheet1'!I41:I43, "On hold")

[rayted]

Bingo, thank you!

[MarvinP]

Hi rayted,

A sample workbook would allow us to give a better answer but two possible answers are...

=Countif(first range) + CountIf(second range)

or

Try using the CountIfs() function.
https://www.techonthenet.com/excel/f...s/countifs.php

[rayted]

thanks MarvinP.

davsth provided the response prior and both your and their response has helped. thank you!

[kvsrinivasamurthy]

Try this

=SUMPRODUCT(COUNTIF(Sheet1!I2:I39,I41:I43))

[MarvinP]

Hi rayted,

If you have a good answer for your problem, you should mark it as solved, so others don't need to try and give an answer.

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

[rayted]

Sorry - marked as solved now!