Using IF function

February 9, 2011 at 06:21:14
Specs: Windows XP

I have used an array formula

=COUNT(IF('Country Late Tasks'!$D$2:$D$436='WEEKLY REPORT'!$C$9,IF('Country Late Tasks'!$C$2:$C$436='WEEKLY REPORT'!B28,'Country Late Tasks'!$AA$2:$AA$436)))

Now i need to have a consolidated result of all values from tab country late column C and column D

Please help

See More: Using IF function

Report •

February 9, 2011 at 07:09:40
Have you tried SUMPRODUCT?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question