Need Help with Formula! HELP!

[carla7216]

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

 

[par60056]

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

 

[carla7216]

That worked!
Thanks so much par60056!!!!!