Need Help with Formula! HELP!

carla7216

New Member
Joined
Aug 13, 2009
Messages
23
Hello anyone and everyone,

I need help with this formula.

Criteria= I have these three telephone numbers below and I want to calculate the # of times called for each but combined to one total. Here's the formula that I used but the return is = #VALUE!

=COUNTIF(D12:D77,"203-744-9206")*("203-948-0749")*("203-948-2647")

What am I doing wrong?

Please help! I'd greatly appreciate it. Thanks so much
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

par60056

Well-known Member
Joined
Jul 26, 2012
Messages
1,581
Office Version
  1. 2011
  2. 2010
Platform
  1. Windows
  2. MacOS
try:
=COUNTIF(D12:D77,"203-744-9206")+COUNTIF(D12:D77,"203-948-0749")+COUNTIF(D12:D77,"203-948-2647")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,968
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top