Question about Computers & Internet

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

can you tell us what product this is, brand and model.

Jun 23, 2008 | Computers & Internet

In the cell that you
want the result to appear in, enter the appropriate formula from the following
examples.

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

Sub Dist1()

'

' Dist1 Macro

'

' Keyboard Shortcut: Ctrl+Shift+D

'

Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _

TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _

Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _

:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), _

TrailingMinusNumbers:=True

End Sub

Sub Dist2()

'

' Dist2 Macro

'

' Keyboard Shortcut: Ctrl+Shift+M

'

Selection.Copy

ActiveCell.Offset(0, 2).Range("A1").Select

Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=True

End Sub

if have any probs pl contact me

Zulfikar Ali

ali_zulfikar@yahoo.com

09899780221

Mar 19, 2009 | Microsoft Office Professional 2007 Full...

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

Make sure you have the latest firmware downloads for your ServStation. The latest release - 6.11 - has upgrades for the latest Mac operating systems. If you're switching to a PC based solution you shouldn't have any problems connecting to the ServStation. If you still are, what exactly is the error you are seeing?

- John

Technical Support

www.primearray.com

- John

Technical Support

www.primearray.com

Jun 23, 2008 | Computers & Internet

I was afraid of that. The only way to connect is by ip. and you already tried that. so, why can't you see the admin screen.

what type of operating system are you using on the computer you are trying to connect to the servstation?

The last one I tried from was MS Server. Are you using windows or mac, what version, etc?

what type of operating system are you using on the computer you are trying to connect to the servstation?

The last one I tried from was MS Server. Are you using windows or mac, what version, etc?

Jun 23, 2008 | Computers & Internet

No, you are no trouble. Sorry, to make you think so. Let me see what else I can come up with. I used to be a teacher at a school and I know this is very frustrating because of the lack of funding.

Jun 23, 2008 | Computers & Internet

Is this owned by a school. If it is, many local technology centers will come and work on this for free. Without seeing the device myself it will be hard because finding a tech manual for this item is difficult.

Did PrimeArray know this belonged to a school?

Did PrimeArray know this belonged to a school?

Jun 23, 2008 | Computers & Internet

I know ATA disks are cheaper , but they don't last as long or are less reliable.

I do not recommend mixing SCSI and ATA .

Use one or the other , not both.

Do not try , unless your server is non critical.

If it is non critical , why bother with server , a PC will do as well.

Thanks

David

I do not recommend mixing SCSI and ATA .

Use one or the other , not both.

Do not try , unless your server is non critical.

If it is non critical , why bother with server , a PC will do as well.

Thanks

David

May 14, 2008 | HP Compaq ProLiant DL380 G4 Server

64 people viewed this question

Usually answered in minutes!

×