Re: Count the times a value appears in a column based on another value

Tech-Archive recommends: Speed Up your PC by fixing your registry

Try this:

=SUMPRODUCT(('List of Reviews'!B1:B1000="Web")*('List of Reviews'!
D1:D1000=1))

Adjust the ranges to suit your data, but you can't use full-column
references (unless you are using XL2007, in which case you could
probably use COUNTIFS).

Hope this helps.

Pete


On Dec 31, 12:45 am, TrainingGuru
<TrainingG...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am using the following formula to count the number of times "Web" appears
in column B based on "1" being in column D:

=IF('List of Reviews'!B:B="Web",COUNTIF('List of Reviews'!D:D,1),0)

I continue to get a #NUM! error for the logical test in the IF statement
even when the formula is reversed and I try to count the number of times
"Web" appears for every row which contains a "1" in column D. What is wrong
with the formula? Is there another function that will return the correct
result? Just a note: The COUNTIF function works each time to find the right
value for the criteria entered. Help needed quickly! Thanks.

.

Relevant Pages

  • Re: stop automatically changing fomula ...
    ... Take a look at Help's "The difference between relative and absolute ... references" topic. ... > i have a countif function ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Using the CountIf function with multiple criteria?
    ... Adjust the range to suit your data. ... have a specific name, that has a "Yes Flag" for another field ... with the specific name (which I can do using just the countif function), ...
    (microsoft.public.excel.worksheet.functions)