Posts by pmgmd

Re: Number every 99th cell

Thank you, yet this is way above what I am familiar with. Is there a more simplified way.

I have 10000 rows and I need to number every 99th row. How can I do this.

Thank you,

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

Re: If And Function

Thank you!!!

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,

Re: If Function - Conditional

Thank you. That did it.

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

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

Re: Sumproduct/Countif

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

Re: Using Sumproduct for multiple criterias

I am new at this. Thank you

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