Countif?/Vlookup?/Macros???

[praveen_khm]

Hi all,

I have attached a spreadsheet and I have given my clarifications here.

The data is given in sheet 1. I need the output in the sheet 2. I can as well use formulas but since I am not able to use "this condition AND this condition" type in the sheet, it is not possible for me to solve this. I simply need the count of the people in sheet 2. i.e, In sheet 2, C4, I need the count of all AUS AP as of in January. Please help. This is very urgent and I am not able to find any way. I cant use vlookup and use it for single perticular cell as it takes days to complete. Also, COUNTIF condition can be used on one criteria and i can't use this for two conditions. Please Please help. I would appreciate your quick response.

Thanks in advance,
Praveen.

[Jim Thomlinson]

Sumproduct will do thiat for you. Check out this link.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"praveen_khm" wrote:

>
> Hi all,
>
> I have attached a spreadsheet and I have given my clarifications here.
>
>
> The data is given in sheet 1. I need the output in the sheet 2. I can
> as well use formulas but since I am not able to use "this condition AND
> this condition" type in the sheet, it is not possible for me to solve
> this. I simply need the count of the people in sheet 2. i.e, In sheet
> 2, C4, I need the count of all AUS AP as of in January. Please help.
> This is very urgent and I am not able to find any way. I cant use
> vlookup and use it for single perticular cell as it takes days to
> complete. Also, COUNTIF condition can be used on one criteria and i
> can't use this for two conditions. Please Please help. I would
> appreciate your quick response.
>
> Thanks in advance,
> Praveen.
>
>
> +-------------------------------------------------------------------+
> |Filename: Content.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4316 |
> +-------------------------------------------------------------------+
>
> --
> praveen_khm
> ------------------------------------------------------------------------
> praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
> View this thread: http://www.excelforum.com/showthread...hreadid=508291
>
>

[praveen_khm]

Thanks a lot Jim.

Your help is really appreciated.

Thanks a lot.