Count and Count if funtions

G

Guest

My previous question perhaps was not worded correctly.
What is the specific text for using the count of countif funtions with two
criteria with both criteria to be met for the cell to be counted example

Countif A1:A5 equals f AND D1:D5 equals 0

Count A1:A5 AND D1:D5 (sum should only count one cell within the same row)
 
G

Guest

Debi -
The formula's I gave in response to your last post were the exact formula's
you needed... all you have to do is copy the formula's (verbatim) and paste
into your spreadsheet.
 
G

Guest

Thank you very much this saves me a great deal of timew ands reduce
redundancy. I greatly appreciate your assistance!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula format for Count or Countif funtion with two criterias 2
Countif Function Using "AND" 3
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
function to use to count value 9
Excel Need Countifs Formula Help 0
CountIf previous cell formula 0
how to count if a cell value falls between two numbers 4
EQUIVALENT for this FORMULA , please 1

Top