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.


+-------------------------------------------------------------------+
|Filename: Content.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4316 |
+-------------------------------------------------------------------+

 

[Guest]

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

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

 

[praveen_khm]

Thanks a lot Jim.

Your help is really appreciated.

Thanks a lot. :