Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL Function COUNTIF

EXCEL Function COUNTIF

ResolvedVersion 2003

Tue 29 Jul 2008, 11:00 Delegate Sophia said...

Sophia has attended:
No courses

EXCEL Function COUNTIF

Hi,

I would like to know if there is a formula for "countif" but that could meet two given condition.
So IF A1=10 and B1=A, C1=1.

Thank you very much,

Sofia

Tue 29 Jul 2008, 11:20 Trainer Amanda said...

RE: EXCEL Function COUNTIF

Hi Sophia

Thank you for your post.

I've attached an example using the cell entries you have provided above, which I think answers your question.

I've coloured the cell containing the formula in yellow.

I hope you find this useful.
Amanda

Attached files...

count_with_conditions.xls

Tue 29 Jul 2008, 11:39 Delegate Sophia said...

RE: EXCEL Function COUNTIF

Thank you very very much!!!!!!!

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

EXCEL Function COUNTIF

EXCEL Function COUNTIF

RE: EXCEL Function COUNTIF

Attached files...

RE: EXCEL Function COUNTIF

Excel articles

Excel tip:

Cycling through Absoulte cell references