Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Countif after checking two cumulative condition (https://www.askmehelpdesk.com/showthread.php?t=458761)

  • Mar 18, 2010, 10:49 PM
    nikeshtnt
    1 Attachment(s)
    Countif after checking two cumulative condition
    Hi Friends,

    I have a big list of Client list with start and end date. It gets changed every time and I need to prepare a summary movement report. I tried on formula but it gives #VALUE! As result.

    Please check and let me know what is wrong in my formula. Attd a sample sheet.
  • Mar 18, 2010, 11:12 PM
    JBeaucaire
    1 Attachment(s)

    I believe SUMPRODUCT() is your needed formula. When I use it though, I get different results than you do. Either way, examine the syntax of the formula and see if:

    1) my answers are actually correct... use the formulas as is
    2) once you grasp the SUMPRODUCT() syntax, tweak it until you get the results you want.
  • Mar 19, 2010, 03:06 AM
    nikeshtnt

    Thanks JB it works

  • All times are GMT -7. The time now is 11:53 PM.