Gossamer Forum
Home : General : Internet Technologies :

CountIF in Excel

Quote Reply
CountIF in Excel

I have a problem with COUNTIF. It checks only one column. If I want to count two columns..suppose If column1 is equal to 0 and column 2 is also 0 then I want to put the value.

please advice for counting multiple columns in excel to use in a pivot table

Quote Reply
Re: [ksrhyd] CountIF in Excel In reply to
try something like this..

=IF(A1=0,IF(B1=0,"both zero","first zero not both zero"),"not both zero")

this is a typical nested if, you can nest to your heart's content.