Re: Number every 99th cell
Thank you, yet this is way above what I am familiar with. Is there a more simplified way.
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