Thursday, 16 January 2020

windows - How to count two different column?

I really need your help regarding the below table, I need a formula to show me how many pending/closed for each project.


Project Status                      Project    Pending  Closed
VIVA closed VIVA 1 2
ZAIN closed ZAIN 1 1
VIVA PENDING WATANIA 1 0
WATANIA closed
ZAIN PENDING
VIVA closed

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...