Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used Products

March
Sun Mon Tue Wed Thu Fri Sat

14

2014
Months
Mar

### Fri, Mar 14, 2014 10:30 pm

Excel countifs function

Microsoft Excel, starting with Excel 2007, provides a function, `countifs`, to count the number of occurrences of some item while stipulating multiple criteria be met. The function also is available in Microsoft® Excel® 2008 for Mac. The function works like the ``` countif``` function, but whereas `countif` only permits one criteria to be stipulated, `countifs` supports one or more criteria. The syntax for `countifs` is:

``` COUNTIFS( criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n] ) ```

As an example, suppose I have the following worksheet in a spreadsheet:

<> A B C D
1 NumberProjectApprovedFunded
238397Alpha2/12/14N
338400Alpha2/7/14Y
438407Beta3/4/14N
538408Alpha2/25/14N
638409Epsilon3/14/14Y
738412Gamma3/14/14Y
838413Zeta3/14/14Y
938415Alpha3/14/14N
10
11 Approved today 4
12 Approved and funded today 3

Number represents work request numbers associated with various projects. Column C has dates for when the work requests were approved with today's date being March 14, 2014. Column D indicates whether the requests have been funded with a "Y" for "yes" and a "N" for "no".

If I wished to count the number of work requests funded today, I could use the formula `=COUNTIF(C2:C10,TODAY())` in cell B11. COUNTIF works because I have only one criteria. But, if I wanted to count the number that were approved and funded today, then I would need to use COUNTIFS rather than COUNTIF. I could use the formula `=COUNTIFS(C2:C10,TODAY(),D2:D10,"Y")` in cell B12.

### Fri, Mar 14, 2014 9:55 am

Netsh command to show available Wi-Fi networks

On a system running Microsoft Windows, you can see the available Wi-Fi networks near the system,the signal strengths, channel numbers, etc. for each from a command prompt using the command ```netsh show networks mode=Bssid```
```C:\Users\JDoe>netsh
netsh>wlan
netsh wlan>show networks mode=Bssid

Interface name : Wi-Fi
There are 5 networks currently visible.

SSID 1 : 558935
Network type            : Infrastructure
Authentication          : WPA2-Personal
Encryption              : CCMP
BSSID 1                 : 0c:54:a5:48:19:e5
Signal             : 81%
Radio type         : 802.11n
Channel            : 1
Basic rates (Mbps) : 1 2 5.5 11
Other rates (Mbps) : 6 9 12 18 24 36 48 54

SSID 2 : Haze
Network type            : Infrastructure
Authentication          : WPA2-Personal
Encryption              : CCMP
BSSID 1                 : 94:44:52:5a:54:54
Signal             : 83%
Radio type         : 802.11n
Channel            : 11
Basic rates (Mbps) : 1 2 5.5 11
Other rates (Mbps) : 6 9 12 18 24 36 48 54

SSID 3 : 08FX02038916
Network type            : Infrastructure
Authentication          : Open
Encryption              : WEP
BSSID 1                 : 00:18:3a:8a:01:c5
Signal             : 49%
Radio type         : 802.11g
Channel            : 6
Basic rates (Mbps) : 1 2 5.5 11
Other rates (Mbps) : 6 9 12 18 24 36 48 54

SSID 4 : linksys
Network type            : Infrastructure
Authentication          : Open
Encryption              : None
BSSID 1                 : 00:13:10:fa:ef:a3
Signal             : 45%
Radio type         : 802.11g
Channel            : 6
Basic rates (Mbps) : 1 2 5.5 11
Other rates (Mbps) : 6 9 12 18 24 36 48 54

SSID 5 : Hickox
Network type            : Infrastructure
Authentication          : Open
Encryption              : WEP
BSSID 1                 : 0c:d5:02:c5:e8:8c
Signal             : 48%
Radio type         : 802.11g
Channel            : 11
Basic rates (Mbps) : 1 2 5.5 11
Other rates (Mbps) : 6 9 12 18 24 36 48 54

netsh wlan>```