# Count ifs in excel 2003

1. ## Count ifs in excel 2003

Dear all,

Kindly find the attached file and help as per the requirement

Regards
Pranavesh

2. ## Re: Count ifs in excel 2003

In B2 and copy down and across??

=SUMPRODUCT((Sheet1!\$D\$3:\$D\$20=Sheet2!B\$1)*(Sheet1!\$E\$3:\$AG\$20="N")*(Sheet1!\$E\$2:\$AG\$2=Sheet2!\$A2))

3. ## Re: Count ifs in excel 2003

Thanks a ton fro your prompt response

Regards
Pranavesh

4. ## Re: Count ifs in excel 2003

........................

5. ## Re: Count ifs in excel 2003

Hey Fortis,

Small correction in the same formula that you just provided, when checked with the rough sheet which i provided you a a format, it worked on properly

But When checked with the original file, it gave me an error as (#N/A), request you to solve the same

7. ## Re: Count ifs in excel 2003

It's because SUMPRODUCT, needs to use same ranges... You use this formula.

=SUMPRODUCT(('Evaluation Sheet'!\$J\$4:\$J\$38=D\$3)*('Evaluation Sheet'!\$N\$4:\$AP\$36="N")*('Evaluation Sheet'!\$N\$3:\$AP\$3=NFA!\$B4))

Use this.

=SUMPRODUCT(('Evaluation Sheet'!\$J\$4:\$J\$38=D\$3)*('Evaluation Sheet'!\$N\$4:\$AP\$38="N")*('Evaluation Sheet'!\$N\$3:\$AP\$3=NFA!\$B4))

8. ## Re: Count ifs in excel 2003

Thanks a ton
as you said, every range should be equal

It worked on....

Regards
Pranavesh

9. ## Re: Count ifs in excel 2003

Thanks a ton
as you said, every range should be equal

It worked on....

Regards
Pranavesh

10. ## Re: Count ifs in excel 2003

........................

There are currently 1 users browsing this thread. (0 members and 1 guests)