IF and COUNTIF Together

[vioravis]

I have a problem where I have to check for two conditions, one using IF and another using COUNTIF. If both are true, then calculation is done to get a value. If not, the value should be zero. I have given the code below which is not working properly. Can someone please help me how to handle this? Thanks.

Please Login or Register  to view this content.

[oldchippy]

Is this the answer?

Please Login or Register  to view this content.

Put the sheet names in as well

[vioravis]

Thanks. this works fine.

[oldchippy]

Glad to hear it - thanks for the feedback

[asterobelix]

Hi, Could you help me?

I made a formula:

=COUNTIFS(brut!$B:$B;"1T";brut!$G:$G;"F25"; brut!$C:$C;"1") and it works fine, but I need four more conditions - brut!$C$C; "2", brut!$C$C; "3", brut!$C$C; "4" and brut!$C$C; "5".

When I change the formula to =COUNTIFS(brut!$B:$B;"1T";brut!$G:$G;"F25"; brut!$C:$C;"1"; brut!$C$C; "2"; brut!$C$C; "3"; brut!$C$C; "4"; brut!$C$C; "5") it didn't work anymore.

I dont't know how to use IF and COUNTIFS together.

Thanks in advance,

regards from Brazil

[ThirtyTwo]

Hi, Could you help me?

I made a formula:

=COUNTIFS(brut!$B:$B;"1T";brut!$G:$G;"F25"; brut!$C:$C;"1") and it works fine, but I need four more conditions - brut!$C$C; "2", brut!$C$C; "3", brut!$C$C; "4" and brut!$C$C; "5".

When I change the formula to =COUNTIFS(brut!$B:$B;"1T";brut!$G:$G;"F25"; brut!$C:$C;"1"; brut!$C$C; "2"; brut!$C$C; "3"; brut!$C$C; "4"; brut!$C$C; "5") it didn't work anymore.

I dont't know how to use IF and COUNTIFS together.

Thanks in advance,

regards from Brazil

This thread will now be marked as SOLVED, as the OP is satisfied with the solution provided for their specific problem

Please continue your quest to a solution for your problem in your own thread -> http://www.excelforum.com/excel-form...ame-range.html

It helps to keep the forums neat and tidy, one problem per thread is enough