Posts by pmgmd

    Hi,


    I am working off a seperate worksheet and trying to use a Sumproduct with multiple criterias along with one criteria that calculate all fileds that =<45. The formula I am using is listed below. I get #VALUE!


    =SUMPRODUCT(--('Q2-PDR Query BW'!A1:A200="Yes"),--('Q2-PDR Query BW'!B1:B200="Health Net"),--('Q2-PDR Query BW'!C1:C200="Closed"),--('Q2-PDR Query BW'!U1:U200="<=45"))


    Any assistance is much appreciated.


    Thanks,


    Brian

    I am looking for some assistance on how to put together a function that will provide for me 1 of 3 results, (lower than, higher than or similar to).


    What I would like to do is have a function to have the results for column B, be either "lower than", "higher than" or "similar to" based on column A. Column A will have a range of %'s from -100% to 100%


    What I would like happen is the following results for cloumn B, based on column A.


    If Column A is:


    Between -5% and 5% - Then cloumn B = "similar to"
    >5% - Then cloumn B = "higher than"
    >-5% - Then cloumn B = "lower than"


    Thank you,

    I am looking for some assistance on how to put together a function that will provide for me 1 of 3 results, (0, 1 or 2).


    Example Attached


    What I would like to do is have a function to have the results for the "Pts" (D) Column be either 0, 1 or 2 based on the following.


    PM (D)<1.84 (F:10) = 2
    PM (D)<2.25 (E:10), >1.84 (F:10) = 1
    PM (D)>2.25 (E:10) = 0


    Sounds confusing. Any help is much appreciated

    Files

    Hello,


    I need to know how to prevent the changing of my formula when copying and pasting down to other cells.


    Example: =NETWORKDAYS(H92,O92,R2:R8) changes to =NETWORKDAYS(H93,O93,R3:R9) then to =NETWORKDAYS(H94,O94,R4:R10) and so on.


    I need the cell range of R2:R8 to stay the same.


    Thank you,


    Brian

    Re: Sumproduct/Countif


    Hi Aaron thanks for responding. I am not affiliated with Business Warehouse.


    Anyway I'm still getting "#VALUE!" in the cell.


    Thanks

    Sumproduct/Countif


    Hi,


    I am working off a seperate worksheet and trying to use a Sumproduct with multiple criterias along with one criteria that calculate all fileds that =<45. The formula I am using is listed below. I get #VALUE!


    =SUMPRODUCT(--('Q2-PDR Query BW'!A1:A200="Yes"),--('Q2-PDR Query BW'!B1:B200="Health Net"),--('Q2-PDR Query BW'!C1:C200="Closed"),--('Q2-PDR Query BW'!U1:U200="<=45"))


    Any assistance is much appreciated.


    Thanks,


    Brian

    Hi,


    I am working off a seperate worksheet and trying to use a Sumproduct with multiple criterias along with one criteria that calculate all fileds that =<45. The formula I am using is listed below. I get #VALUE!


    =SUMPRODUCT(--('Q2-PDR Query BW'!A1:A200="Yes"),--('Q2-PDR Query BW'!B1:B200="Health Net"),--('Q2-PDR Query BW'!C1:C200="Closed"),--('Q2-PDR Query BW'!U1:U200="<=45"))


    Any assistance is much appreciated.


    Thanks,


    Brian

    I am trying to calculate a total count with in a certian criteria. I have 4 Columns.


    Report: Yes or No
    Health Plan: Listing health Plans
    Contracted: Yes or No
    Final Disposistion: Uphold But Pay By Exception and Upheld by Utilization Management Committee



    I am trying to set a criteria of Reports that will list Reports as yes under a certain health plan with a Contract Status of Yes and with a Final Disposistion of Uphold But Pay By Exception and Upheld by Utilization Management Committee


    I am getting a value of zero when using the following formula.


    =SUMPRODUCT(--(A1:A15="Yes"),--(B1:B15="Blue Cross MediCal"),--(G1:G15="No"),--(I1:I15="Uphold But Pay By Exception"),--(I1:I15="Upheld by Utilization Management Committee"))


    Any suggestions?


    Thanks in advance,
    Brian