answers.microsoft.com Open in urlscan Pro
184.31.82.138 Public Scan

Go To Rescan
Add Verdict Report

URL:
https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22...
Submission: On March 14 via manual (March 14th 2019, 6:29:01 pm UTC) from US

Summary HTTP 31 Redirects Links 84 Behaviour Indicators

Summary

This website contacted 13 IPs in 5 countries across 7 domains to perform 31 HTTP transactions. The main IP is 184.31.82.138, located in Amsterdam, Netherlands and belongs to AKAMAI-ASN1, US. The main domain is answers.microsoft.com.
TLS certificate: Issued by Microsoft IT TLS CA 2 on April 24th 2018. Valid for: 2 years.

This is the only time answers.microsoft.com was scanned on urlscan.io!

urlscan.io Verdict: No classification

Domain & IP information

	IP Address	AS Autonomous System
6	184.31.82.138 184.31.82.138	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
3	2a02:26f0:6c0... 2a02:26f0:6c00::210:ba22	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
5	2a02:26f0:6c0... 2a02:26f0:6c00:287::2ed9	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
3	2a02:26f0:6c0... 2a02:26f0:6c00:286::2b57	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
1	2a02:26f0:6c0... 2a02:26f0:6c00::210:ba1b	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
1	52.178.161.50 52.178.161.50	8075 (MICROSOFT...) (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation)
1	152.199.19.160 152.199.19.160	15133 (EDGECAST) (EDGECAST - MCI Communications Services)
3	2a02:26f0:6c0... 2a02:26f0:6c00:18d::37	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
1	2a02:26f0:6c0... 2a02:26f0:6c00:187::356e	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
2	2a02:26f0:6c0... 2a02:26f0:6c00:28b::356e	20940 (AKAMAI-ASN1) (AKAMAI-ASN1)
4	40.77.226.250 40.77.226.250	8075 (MICROSOFT...) (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation)
1	2a01:111:2010... 2a01:111:2010:6::ff16	8075 (MICROSOFT...) (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation)
31	13

6 184.31.82.138 (Amsterdam, Netherlands)

ASN20940 (AKAMAI-ASN1, US)
PTR: a184-31-82-138.deploy.static.akamaitechnologies.com

answers.microsoft.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

3 2a02:26f0:6c00::210:ba22 (European Union)

ASN20940 (AKAMAI-ASN1, US)

statics-uhf-neu.akamaized.net	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

5 2a02:26f0:6c00:287::2ed9 (European Union)

ASN20940 (AKAMAI-ASN1, US)

answersstaticfilecdn.azureedge.net	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

3 2a02:26f0:6c00:286::2b57 (European Union)

ASN20940 (AKAMAI-ASN1, US)

uhf.microsoft.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

1 2a02:26f0:6c00::210:ba1b (European Union)

ASN20940 (AKAMAI-ASN1, US)

img-prod-cms-rt-microsoft-com.akamaized.net	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

1 52.178.161.50 (Dublin, Ireland)

ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US)

filestore.community.support.microsoft.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

1 152.199.19.160 (Ashburn, United States)

ASN15133 (EDGECAST - MCI Communications Services, Inc. d/b/a Verizon Business, US)

az725175.vo.msecnd.net	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

3 2a02:26f0:6c00:18d::37 (European Union)

ASN20940 (AKAMAI-ASN1, US)

mem.gfx.ms	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

1 2a02:26f0:6c00:187::356e (European Union)

ASN20940 (AKAMAI-ASN1, US)

www.microsoft.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

2 2a02:26f0:6c00:28b::356e (European Union)

ASN20940 (AKAMAI-ASN1, US)

c.s-microsoft.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

4 40.77.226.250 (Dublin, Ireland)

ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US)

web.vortex.data.microsoft.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

1 2a01:111:2010:6::ff16 (United Kingdom)

ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US)

login.live.com	Domain lookup VirusTotal SecurityTrails crt.sh Censys Domaintools

	Apex Domain Subdomains	Transfer
15	microsoft.com answers.microsoft.com uhf.microsoft.com filestore.community.support.microsoft.com www.microsoft.com web.vortex.data.microsoft.com	86 KB
5	azureedge.net answersstaticfilecdn.azureedge.net	343 KB
4	akamaized.net statics-uhf-neu.akamaized.net img-prod-cms-rt-microsoft-com.akamaized.net	61 KB
3	gfx.ms mem.gfx.ms	44 KB
2	s-microsoft.com c.s-microsoft.com	64 KB
1	live.com login.live.com
1	msecnd.net az725175.vo.msecnd.net	18 KB
31	7

	Domain	Requested by
6	answers.microsoft.com	answers.microsoft.com
5	answersstaticfilecdn.azureedge.net	answers.microsoft.com answersstaticfilecdn.azureedge.net
4	web.vortex.data.microsoft.com	az725175.vo.msecnd.net
3	mem.gfx.ms	answers.microsoft.com mem.gfx.ms
3	uhf.microsoft.com	answers.microsoft.com answersstaticfilecdn.azureedge.net
3	statics-uhf-neu.akamaized.net	answers.microsoft.com
2	c.s-microsoft.com	answers.microsoft.com
1	login.live.com	mem.gfx.ms
1	www.microsoft.com	answers.microsoft.com
1	az725175.vo.msecnd.net	answers.microsoft.com
1	filestore.community.support.microsoft.com	answers.microsoft.com
1	img-prod-cms-rt-microsoft-com.akamaized.net	answers.microsoft.com
31	12

This site contains links to these domains. Also see Links.

Domain
go.microsoft.com
www.microsoft.com
products.office.com
www.xbox.com
support.microsoft.com
onedrive.live.com
outlook.live.com
www.skype.com
www.onenote.com
azure.microsoft.com
enterprise.microsoft.com
visualstudio.microsoft.com
developer.microsoft.com
docs.microsoft.com
store.office.com
account.microsoft.com
partner.microsoft.com
msdn.microsoft.com
technet.microsoft.com
channel9.msdn.com
careers.microsoft.com
news.microsoft.com
privacy.microsoft.com
choice.microsoft.com

Subject Issuer	Validity	Valid
answers.microsoft.com Microsoft IT TLS CA 2	`2018-04-24` - `2020-04-24`	2 years	crt.sh
a248.e.akamai.net DigiCert ECC Secure Server CA	`2018-10-18` - `2019-10-18`	a year	crt.sh
*.azureedge.net Microsoft IT TLS CA 1	`2018-10-17` - `2020-10-17`	2 years	crt.sh
unistore.www.microsoft.com Microsoft IT TLS CA 5	`2018-01-25` - `2020-01-25`	2 years	crt.sh
*.community.support.microsoft.com Microsoft IT TLS CA 2	`2018-02-06` - `2020-02-06`	2 years	crt.sh
*.vo.msecnd.net Microsoft IT TLS CA 2	`2018-03-30` - `2020-03-30`	2 years	crt.sh
mem.gfx.ms Microsoft IT TLS CA 2	`2018-02-05` - `2020-02-05`	2 years	crt.sh
www.microsoft.com Microsoft IT TLS CA 4	`2018-01-16` - `2020-01-16`	2 years	crt.sh
*.vortex.data.microsoft.com Microsoft IT TLS CA 5	`2018-01-30` - `2020-01-30`	2 years	crt.sh
*.login.live.com Microsoft IT TLS CA 2	`2018-06-29` - `2020-06-29`	2 years	crt.sh

This page contains 2 frames:

Primary Page: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Frame ID: 046F23153941ED19F0DC82993A8070DB
Requests: 31 HTTP requests in this frame

Frame: https://login.live.com/me.srf?wa=wsignin1.0&wreply=https%3A%2F%2Fanswers.microsoft.com&uaid=af62fb3b-cbc8-4ea0-3575-8a3803cbec52&partnerId=msanswers
Frame ID: 0FBF2063336736DA09A593CF80754900
Requests: 1 HTTP requests in this frame

Screenshot
Live screenshot

Full Image

Detected technologies

ClickTale (Analytics) Expand

Overall confidence: 100%
Detected patterns

env /^ClickTale/i

Modernizr (JavaScript Libraries) Expand

Overall confidence: 100%
Detected patterns

env /^Modernizr$/i

jQuery (JavaScript Libraries) Expand

Overall confidence: 100%
Detected patterns

env /^jQuery$/i

Page Statistics

31
Requests

100 %
HTTPS

67 %
IPv6

7
Domains

12
Subdomains

13
IPs

5
Countries

614 kB
Transfer

2641 kB
Size

6
Cookies

84 Outgoing links

These are links going to different origins than the main page.

URL: https://go.microsoft.com/fwlink/?linkid=845480
Title: Learn more

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/
Title: Microsoft

Search URL Search Domain Scan URL

URL: https://products.office.com/en-us/home
Title: Office

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/windows/
Title: Windows

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/surface
Title: Surface

Search URL Search Domain Scan URL

URL: https://www.xbox.com/
Title: Xbox

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/b/sale?icid=gm_nav_L0_salepage
Title: Deals

Search URL Search Domain Scan URL

URL: https://support.microsoft.com/en-us
Title: Support

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/windows/windows-10-apps
Title: Windows apps

Search URL Search Domain Scan URL

URL: https://onedrive.live.com/about/en-us/
Title: OneDrive

Search URL Search Domain Scan URL

URL: https://outlook.live.com/owa/
Title: Outlook

Search URL Search Domain Scan URL

URL: https://www.skype.com/en/
Title: Skype

Search URL Search Domain Scan URL

URL: https://www.onenote.com/
Title: OneNote

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/windows/devices
Title: PCs & tablets

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/accessories/en-us
Title: Accessories

Search URL Search Domain Scan URL

URL: https://www.xbox.com/en-us/games/xbox-one?xr=shellnav
Title: Xbox games

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/windows/windows-10-games
Title: PC games

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/games/windows?icid=TopNavWindowsGames
Title: Windows digital games

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/movies-and-tv?icid=TopNavMoviesAndTv
Title: Movies & TV

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/books
Title: Books

Search URL Search Domain Scan URL

URL: https://azure.microsoft.com/en-us/
Title: Microsoft Azure

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/dynamics365/home
Title: Microsoft Dynamics 365

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/microsoft-365/?omkt=en-US
Title: Microsoft 365

Search URL Search Domain Scan URL

URL: https://enterprise.microsoft.com/en-us/
Title: Microsoft Industry

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/sql-server/
Title: Data platform

Search URL Search Domain Scan URL

URL: https://go.microsoft.com/fwlink/?linkid=2026638
Title: Microsoft Advertising

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/net/
Title: .NET

Search URL Search Domain Scan URL

URL: https://visualstudio.microsoft.com/
Title: Visual Studio

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/cloud-platform/windows-server
Title: Windows Server

Search URL Search Domain Scan URL

URL: https://developer.microsoft.com/en-us/windows
Title: Windows Dev Center

Search URL Search Domain Scan URL

URL: https://docs.microsoft.com/en-us/
Title: Docs

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/b/home
Title: Microsoft Store

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/rewards
Title: Microsoft Rewards

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/download/default.aspx
Title: Free downloads & security

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/education?icid=CNavMSCOML0_Studentsandeducation
Title: Education

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/locations/find-a-store?icid=TopNavStoreLocations
Title: Store locations

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/b/gift-cards
Title: Gift cards

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/sitemap.aspx
Title: View Sitemap

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/p/surface-pro-6/8ZCNC665SLQ5
Title: NEW Surface Pro 6

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/p/surface-laptop-2/8XQJKK3DD91B
Title: NEW Surface Laptop 2

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/p/surface-go/8v9dp4lnknsz
Title: NEW Surface Go

Search URL Search Domain Scan URL

URL: https://www.xbox.com/en-us/xbox-one-x
Title: Xbox One X

Search URL Search Domain Scan URL

URL: https://www.xbox.com/en-us/xbox-one-s?xr=shellnav
Title: Xbox One S

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/b/virtualreality
Title: VR & mixed reality

Search URL Search Domain Scan URL

URL: https://store.office.com/en-us/appshome.aspx
Title: Office apps

Search URL Search Domain Scan URL

URL: https://account.microsoft.com/
Title: Account profile

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/download
Title: Download Center

Search URL Search Domain Scan URL

URL: https://go.microsoft.com/fwlink/p/?LinkID=824761&clcid=0x409
Title: Sales & support

Search URL Search Domain Scan URL

URL: https://go.microsoft.com/fwlink/p/?LinkID=824764&clcid=0x409
Title: Returns

Search URL Search Domain Scan URL

URL: https://account.microsoft.com/orders
Title: Order tracking

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/locations/find-a-store?icid=en-us_UF_FAS
Title: Store locations

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/b/buy-online-pick-up-in-store?icid=uhf_footer_bopuis
Title: Buy online, pick up in store

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/education
Title: Microsoft in education

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/education/products/office/default.aspx
Title: Office for students

Search URL Search Domain Scan URL

URL: https://products.office.com/en-us/academic/compare-office-365-education-plans
Title: Office 365 for schools

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/store/b/education?icid=CNavfooter_Studentsandeducation
Title: Deals for students & parents

Search URL Search Domain Scan URL

URL: https://azure.microsoft.com/en-us/community/education/
Title: Microsoft Azure in education

Search URL Search Domain Scan URL

URL: https://azure.microsoft.com/
Title: Microsoft Azure

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/solution-providers
Title: Find a solution provider

Search URL Search Domain Scan URL

URL: https://partner.microsoft.com/en-us/
Title: Microsoft partner resources

Search URL Search Domain Scan URL

URL: https://go.microsoft.com/fwlink/?LinkID=808093
Title: Microsoft AppSource

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/enterprise/health
Title: Health

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/enterprise/finance/banking-capital-markets
Title: Financial services

Search URL Search Domain Scan URL

URL: https://msdn.microsoft.com/en-us
Title: Developer Network

Search URL Search Domain Scan URL

URL: https://technet.microsoft.com/en-us
Title: TechNet

Search URL Search Domain Scan URL

URL: https://developer.microsoft.com/en-us/store/register
Title: Microsoft developer program

Search URL Search Domain Scan URL

URL: https://channel9.msdn.com/
Title: Channel 9

Search URL Search Domain Scan URL

URL: https://developer.microsoft.com/en-us/office
Title: Office Dev Center

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/garage/
Title: Microsoft Garage

Search URL Search Domain Scan URL

URL: https://careers.microsoft.com/
Title: Careers

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/about
Title: About Microsoft

Search URL Search Domain Scan URL

URL: https://news.microsoft.com/
Title: Company news

Search URL Search Domain Scan URL

URL: https://privacy.microsoft.com/en-us
Title: Privacy at Microsoft

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/investor/default.aspx
Title: Investors

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/diversity/
Title: Diversity and inclusion

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/accessibility
Title: Accessibility

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/security/default.aspx
Title: Security

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/sitemap1.aspx
Title: Sitemap

Search URL Search Domain Scan URL

URL: https://support.microsoft.com/en-us/contactus
Title: Contact Microsoft

Search URL Search Domain Scan URL

URL: https://go.microsoft.com/fwlink/?LinkId=521839
Title: Privacy & cookies

Search URL Search Domain Scan URL

URL: https://go.microsoft.com/fwlink/?LinkID=206977
Title: Terms of use

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/trademarks
Title: Trademarks

Search URL Search Domain Scan URL

URL: https://www.microsoft.com/en-us/devices/safety-and-eco
Title: Safety & eco

Search URL Search Domain Scan URL

URL: https://choice.microsoft.com/
Title: About our ads

Search URL Search Domain Scan URL

Redirected requests

There were HTTP redirect chains for the following requests:

31 HTTP transactions
1 data transactions

Method
Protocol Status Resource
Path Size
x-fer Time
Latency Type
MIME-Type IP
Location

GET
H2 200 Primary Request 16acea3b-1f22-49ed-9ba8-32975445de83 Show response
answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/ 121 KB
24 KB 311ms
262ms Document
text/html 184.31.82.138
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

184.31.82.138 Amsterdam, Netherlands, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

a184-31-82-138.deploy.static.akamaitechnologies.com

Software

Resource Hash

390294afcf673c3a5c5e9dc93115f4a17adc218bf1503682505bce03ce9337fb

Security Headers

Name	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff
X-Frame-Options	SAMEORIGIN

Request headers

:method: GET
:authority: answers.microsoft.com
:scheme: https
:path: /en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
pragma: no-cache
cache-control: no-cache
upgrade-insecure-requests: 1
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
accept-encoding: gzip, deflate, br
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

status: 200
content-type: text/html; charset=utf-8
server
ms-cv: /5sYWMBCdk6NO0n4PCApXw.0
x-frame-options: SAMEORIGIN
x-ua-compatible: IE=edge
x-content-type-options: nosniff
x-edgeconnect-midmile-rtt: 27
x-edgeconnect-origin-mex-latency: 218
vary: Accept-Encoding
content-encoding: gzip
expires: Thu, 14 Mar 2019 18:28:44 GMT
cache-control: max-age=0, no-cache, no-store no-transform
pragma: no-cache
date: Thu, 14 Mar 2019 18:28:44 GMT
content-length: 23457
set-cookie: cap_f=smc-survey-feat-1|smc-survey-elg-1|vafx-intro-0|filterexposuretest|ce-aatest-0|smc-clicktale|vafx-uc-1|vafx-pip-1|vasf-af-1|vafx-sgst2-1|vafx-snt-1|cf-cx12-1|vafx-icsv21-1|cs-vacontent1-0; domain=answers.microsoft.com; path=/ cap_t=2019-03-14T18:28:44.8014933Z; domain=answers.microsoft.com; path=/ asid=f7bc4b7d-f5b8-49c7-8036-c345f02b6c86; domain=answers.microsoft.com; path=/; HttpOnly
strict-transport-security: max-age=86400 ; includeSubDomains

GET
H/1.1 200
OK 51-6d3a1e
statics-uhf-neu.akamaized.net/west-european/shell/_scrf/css/themes=default.device=uplevel_web_pc/e9-4413b1/4e-bb306d/a9-963a11/10-aee09b/51-465167/1d-9730ee/34-521645/ 160 KB
22 KB 51ms
6ms Stylesheet
text/css 2a02:26f0:6c00::210:ba22
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://statics-uhf-neu.akamaized.net/west-european/shell/_scrf/css/themes=default.device=uplevel_web_pc/e9-4413b1/4e-bb306d/a9-963a11/10-aee09b/51-465167/1d-9730ee/34-521645/51-6d3a1e?ver=2.0

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_ECDSA, AES_256_GCM

Server

2a02:26f0:6c00::210:ba22 , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Microsoft-IIS/10.0 /

Resource Hash

3abc05cf7fcd206115a9f2871547be6a8649c34b2efc0d1f77441147a5a78bc8

Security Headers

Name	Value
X-Content-Type-Options	nosniff
X-Xss-Protection	1

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

ms-operation-id: 9edebd0676fe4f428adb3b606d7073aa
Date: Thu, 14 Mar 2019 18:28:44 GMT
Content-Encoding: gzip
X-Content-Type-Options: nosniff
X-S2: 2019-02-28T23:18:21
P3P: CP="CAO CONi OTR OUR DEM ONL"
X-Activity-Id: 00000000-b303-42ac-94b2-1fd6eab58195
Connection: keep-alive
MS-CV: GeHkTZhP90S4knC+.0
Vary: Accept-Encoding
Content-Length: 21538
X-XSS-Protection: 1
Last-Modified: Thu, 28 Feb 2019 23:18:21 GMT
Server: Microsoft-IIS/10.0
X-Az: {did:-, rid: -, sn: uhf-neu-prod, dt: 2019-02-28T01:37:47.9955527Z, bt: 2019-02-27T00:18:04.0000000Z}
X-S1: 2019-02-28T23:18:21
Access-Control-Allow-Methods: HEAD,GET,POST,PATCH,PUT,OPTIONS
Content-Type: text/css; charset=utf-8
Access-Control-Allow-Origin: *
Cache-Control: public, max-age=30343754
Timing-Allow-Origin: *
X-AppVersion: 1.0.6997.542
Expires: Fri, 28 Feb 2020 23:17:58 GMT

GET
H/1.1 200
OK override.css
statics-uhf-neu.akamaized.net/statics/ 1 KB
938 B 51ms
6ms Stylesheet
text/css 2a02:26f0:6c00::210:ba22
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://statics-uhf-neu.akamaized.net/statics/override.css?c=7
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: HTTP/1.1
Security: TLS 1.2, ECDHE_ECDSA, AES_256_GCM
Server: 2a02:26f0:6c00::210:ba22 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: 0bd288d5397a69ead391875b422bf2cbdcc4f795d64aa2f780aff45768d78248

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
Date: Thu, 14 Mar 2019 18:28:44 GMT
Content-Encoding: gzip
Last-Modified: Tue, 05 Mar 2019 19:05:18 GMT
Server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
ETag: 0x8D6A19D82194196
Vary: Accept-Encoding
Content-Type: text/css
X-EdgeConnect-Cache-Status: 1
x-ms-request-id: a012d831-201e-0092-2587-d3afdf000000
x-ms-version: 2009-09-19
Connection: keep-alive
Content-Length: 473

GET
H2 200 bundle.thread-view-mwfv3.19.3.1.2.min.css
answersstaticfilecdn.azureedge.net/static/css/mwf/bundle/ 859 KB
102 KB 412ms
335ms Stylesheet
text/css 2a02:26f0:6c00:287::2ed9
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://answersstaticfilecdn.azureedge.net/static/css/mwf/bundle/bundle.thread-view-mwfv3.19.3.1.2.min.css
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:287::2ed9 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: 6a675876939fd5caf91a821c09beb43c2a8aa575223dccc2edfb3ce2e22f527c

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:45 GMT
content-encoding: gzip
last-modified: Fri, 01 Mar 2019 20:36:19 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: UaS0e0gvh+NznLeuUhOKlA==
etag: 0x8D69E858FBF53BB
vary: Origin, Accept-Encoding
content-type: text/css
status: 200
x-ms-request-id: 046fc206-601e-0038-4e93-da2b55000000
cache-control: max-age=604793
x-ms-version: 2009-09-19

GET
H2 200 bundle.thread-listv3.19.3.1.2.min.css
answersstaticfilecdn.azureedge.net/static/css/mwf/bundle/ 448 KB
108 KB 909ms
833ms Stylesheet
text/css 2a02:26f0:6c00:287::2ed9
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://answersstaticfilecdn.azureedge.net/static/css/mwf/bundle/bundle.thread-listv3.19.3.1.2.min.css
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:287::2ed9 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: d2d62af2146363f87ae1fc1ced79018db60c952b3ebd6bf2a38264adac19e864

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:45 GMT
content-encoding: gzip
last-modified: Fri, 01 Mar 2019 20:36:19 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: iDJa64fKdT2ItNF+ZTKnng==
etag: 0x8D69E858FBA49C0
vary: Origin, Accept-Encoding
content-type: text/css
status: 200
x-ms-request-id: 893c42fa-701e-0069-3293-dab6d9000000
cache-control: max-age=604780
x-ms-version: 2009-09-19

GET
H2 200 mscc-0.4.1.min.css
uhf.microsoft.com/mscc/statics/ 1 KB
939 B 51ms
8ms Stylesheet
text/css 2a02:26f0:6c00:286::2b57
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://uhf.microsoft.com/mscc/statics/mscc-0.4.1.min.css
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:286::2b57 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: 35211f76c4c35c17f2649b96868c0d691f1d78b107f7635d22619948d0ee6880

Request headers

:path: /mscc/statics/mscc-0.4.1.min.css
pragma: no-cache
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: text/css,*/*;q=0.1
cache-control: no-cache
:authority: uhf.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:44 GMT
content-encoding: gzip
last-modified: Mon, 10 Sep 2018 17:42:23 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: 2MKxgMQLzH/8vixotX2Pog==
status: 200
etag: 0x8D61744C3ED0073
vary: Accept-Encoding
content-type: text/css;charset=utf-8
access-control-allow-origin: *
x-ms-request-id: 89ac9d83-001e-0059-6ffe-49161e000000
x-ms-version: 2009-09-19
content-length: 627

GET
H2 200 RE1Mu3b
img-prod-cms-rt-microsoft-com.akamaized.net/cms/api/am/imageFileData/ 4 KB
4 KB 49ms
5ms Image
image/png 2a02:26f0:6c00::210:ba1b
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to Show image

Full URL: https://img-prod-cms-rt-microsoft-com.akamaized.net/cms/api/am/imageFileData/RE1Mu3b?ver=5c31
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_ECDSA, AES_256_GCM
Server: 2a02:26f0:6c00::210:ba1b , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Microsoft-IIS/10.0 / ASP.NET
Resource Hash: 112fec798b78aa02e102a724b5cb1990c0f909bc1d8b7b1fa256eab41bbc0960

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-cms-cdninvalkey: am:RE1Mu3b
date: Thu, 14 Mar 2019 18:28:44 GMT
x-aspnet-version: 4.0.30319
x-source-length: 4054
x-powered-by: ASP.NET
status: 200
x-activityid: ff2ead7a-36d3-4c81-a81a-62d64071148e
x-deployment: a89a5014e89c41b7b60a64d7ee950637
content-length: 4054
timing-allow-origin: *
last-modified: Tue, 12 Mar 2019 07:38:55 GMT
server: Microsoft-IIS/10.0
x-datacenter: NorthEU
content-type: image/png
access-control-allow-origin: *
cache-control: public, max-age=220249
x-instance: Resizer.Web_IN_1
content-location: https://img-prod-cms-rt-microsoft-com.akamaized.net/cms/api/am/imageFileData/RE1Mu3b?ver=5c31
expires: Sun, 17 Mar 2019 07:39:33 GMT

GET
H2 200 jquery-2.2.4.min.js Show response
answers.microsoft.com/static/js/lib/jquery/ 84 KB
30 KB 9ms
8ms Script
application/javascript 184.31.82.138
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://answers.microsoft.com/static/js/lib/jquery/jquery-2.2.4.min.js

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

184.31.82.138 Amsterdam, Netherlands, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

a184-31-82-138.deploy.static.akamaitechnologies.com

Software

Resource Hash

b409c14a10b4caad6b54844aa63a5faf748b83eecc2dd0d4fb1d913f8de55365

Security Headers

Name	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff

Request headers

:path: /static/js/lib/jquery/jquery-2.2.4.min.js
pragma: no-cache
cookie: cap_f=smc-survey-feat-1|smc-survey-elg-1|vafx-intro-0|filterexposuretest|ce-aatest-0|smc-clicktale|vafx-uc-1|vafx-pip-1|vasf-af-1|vafx-sgst2-1|vafx-snt-1|cf-cx12-1|vafx-icsv21-1|cs-vacontent1-0; cap_t=2019-03-14T18:28:44.8014933Z; asid=f7bc4b7d-f5b8-49c7-8036-c345f02b6c86
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: */*
cache-control: no-cache
:authority: answers.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

date: Thu, 14 Mar 2019 18:28:44 GMT
content-encoding: gzip
x-content-type-options: nosniff
status: 200
ms-cv: lalnlZ8JLkCDZ4fVEUzZpg.0
vary: Accept-Encoding
content-length: 29865
x-ua-compatible: IE=edge
last-modified: Fri, 01 Mar 2019 22:21:56 GMT
server
etag: "01ae42d7dd0d41:0"
strict-transport-security: max-age=86400 ; includeSubDomains
content-type: application/javascript
cache-control: max-age=59492 no-transform
accept-ranges: bytes
expires: Fri, 15 Mar 2019 11:00:16 GMT

GET
H2 200 msoffice.svg
answers.microsoft.com/static/resourceimages/categories/ 591 B
689 B 10ms
9ms Image
image/svg+xml 184.31.82.138
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to Show image

Full URL

https://answers.microsoft.com/static/resourceimages/categories/msoffice.svg

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

184.31.82.138 Amsterdam, Netherlands, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

a184-31-82-138.deploy.static.akamaitechnologies.com

Software

Resource Hash

f2e824b33fc5f37acd5f8bc38ba6f41b9fd9425724820ba5cd9aecad3e2b3c0c

Security Headers

Name	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff

Request headers

:path: /static/resourceimages/categories/msoffice.svg
pragma: no-cache
cookie: cap_f=smc-survey-feat-1|smc-survey-elg-1|vafx-intro-0|filterexposuretest|ce-aatest-0|smc-clicktale|vafx-uc-1|vafx-pip-1|vasf-af-1|vafx-sgst2-1|vafx-snt-1|cf-cx12-1|vafx-icsv21-1|cs-vacontent1-0; cap_t=2019-03-14T18:28:44.8014933Z; asid=f7bc4b7d-f5b8-49c7-8036-c345f02b6c86
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: image/webp,image/apng,image/*,*/*;q=0.8
cache-control: no-cache
:authority: answers.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

date: Thu, 14 Mar 2019 18:28:45 GMT
content-encoding: gzip
x-content-type-options: nosniff
status: 200
ms-cv: 8r/bvxgwqkarh4WMEsm4cw.0
vary: Accept-Encoding
content-length: 393
x-ua-compatible: IE=edge
last-modified: Fri, 01 Mar 2019 22:21:57 GMT
server
etag: "80b07c2e7dd0d41:0"
strict-transport-security: max-age=86400 ; includeSubDomains
content-type: image/svg+xml
cache-control: max-age=21733 no-transform
accept-ranges: bytes
expires: Fri, 15 Mar 2019 00:30:58 GMT

GET
H2 200 answerIconInverted.svg
answers.microsoft.com/static/images/ 1 KB
804 B 8ms
8ms Image
image/svg+xml 184.31.82.138
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to Show image

Full URL

https://answers.microsoft.com/static/images/answerIconInverted.svg

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

184.31.82.138 Amsterdam, Netherlands, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

a184-31-82-138.deploy.static.akamaitechnologies.com

Software

Resource Hash

ed993dd6f4ddfc4efc32560dc921332452c1f9ff46b0758964e8e8b035a94c58

Security Headers

Name	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff

Request headers

:path: /static/images/answerIconInverted.svg
pragma: no-cache
cookie: cap_f=smc-survey-feat-1|smc-survey-elg-1|vafx-intro-0|filterexposuretest|ce-aatest-0|smc-clicktale|vafx-uc-1|vafx-pip-1|vasf-af-1|vafx-sgst2-1|vafx-snt-1|cf-cx12-1|vafx-icsv21-1|cs-vacontent1-0; cap_t=2019-03-14T18:28:44.8014933Z; asid=f7bc4b7d-f5b8-49c7-8036-c345f02b6c86
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: image/webp,image/apng,image/*,*/*;q=0.8
cache-control: no-cache
:authority: answers.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

date: Thu, 14 Mar 2019 18:28:45 GMT
content-encoding: gzip
x-content-type-options: nosniff
status: 200
ms-cv: 76tlgJ4nkEWHrk12S4vemw.0
vary: Accept-Encoding
content-length: 511
x-ua-compatible: IE=edge
last-modified: Fri, 01 Mar 2019 22:21:52 GMT
server
etag: "0c0812b7dd0d41:0"
strict-transport-security: max-age=86400 ; includeSubDomains
content-type: image/svg+xml
cache-control: max-age=22282 no-transform
accept-ranges: bytes
expires: Fri, 15 Mar 2019 00:40:07 GMT

GET
H2 200 7b195ee8-8978-4eea-873c-e950d9cf2f78
filestore.community.support.microsoft.com/api/profileimages/ 6 KB
6 KB 561ms
453ms Image
image/png 52.178.161.50
Microsoft Corpora...

General

Check archive.org

Show headers Download Go to Show image

Full URL: https://filestore.community.support.microsoft.com/api/profileimages/7b195ee8-8978-4eea-873c-e950d9cf2f78
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_128_GCM
Server: 52.178.161.50 Dublin, Ireland, ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US),
Reverse DNS
Software: Microsoft-IIS/10.0 /
Resource Hash: fda883eb2047febd0aaefab176e96e41de0faac258a0ba752456476aab9eab5b

Request headers

:path: /api/profileimages/7b195ee8-8978-4eea-873c-e950d9cf2f78
pragma: no-cache
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: image/webp,image/apng,image/*,*/*;q=0.8
cache-control: no-cache
:authority: filestore.community.support.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

correlationid
pragma: no-cache
date: Thu, 14 Mar 2019 18:28:46 GMT
server: Microsoft-IIS/10.0
content-type: image/png
status: 200
cache-control: no-cache
serverinfo: DB5-DB5BBA
ms-cv: lIBUezFABUa5G0uiupO/Qg.0
content-length: 5740
expires: -1

GET
H2 200 inreplyto.svg
answers.microsoft.com/static/images/ 242 B
509 B 23ms
23ms Image
image/svg+xml 184.31.82.138
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to Show image

Full URL

https://answers.microsoft.com/static/images/inreplyto.svg

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

184.31.82.138 Amsterdam, Netherlands, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

a184-31-82-138.deploy.static.akamaitechnologies.com

Software

Resource Hash

41ab929756123c1ec0a9f778fc98429de6ed7b33b0dda0876816c6c21a8c91f8

Security Headers

Name	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff

Request headers

:path: /static/images/inreplyto.svg
pragma: no-cache
cookie: cap_f=smc-survey-feat-1|smc-survey-elg-1|vafx-intro-0|filterexposuretest|ce-aatest-0|smc-clicktale|vafx-uc-1|vafx-pip-1|vasf-af-1|vafx-sgst2-1|vafx-snt-1|cf-cx12-1|vafx-icsv21-1|cs-vacontent1-0; cap_t=2019-03-14T18:28:44.8014933Z; asid=f7bc4b7d-f5b8-49c7-8036-c345f02b6c86
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: image/webp,image/apng,image/*,*/*;q=0.8
cache-control: no-cache
:authority: answers.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

date: Thu, 14 Mar 2019 18:28:46 GMT
content-encoding: gzip
x-content-type-options: nosniff
status: 200
ms-cv: lgS7x95kskeT27YvXwzxNQ.0
vary: Accept-Encoding
content-length: 214
x-ua-compatible: IE=edge
last-modified: Fri, 01 Mar 2019 22:21:54 GMT
server
etag: "0edb22c7dd0d41:0"
strict-transport-security: max-age=86400 ; includeSubDomains
content-type: image/svg+xml
cache-control: max-age=20693 no-transform
accept-ranges: bytes
expires: Fri, 15 Mar 2019 00:13:39 GMT

GET
H2 200 jquery-2.2.4.min.js Show response
answersstaticfilecdn.azureedge.net/static/js/lib/jquery/ 84 KB
30 KB 1107ms
1046ms Script
application/x-javascript 2a02:26f0:6c00:287::2ed9
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://answersstaticfilecdn.azureedge.net/static/js/lib/jquery/jquery-2.2.4.min.js
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:287::2ed9 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: b409c14a10b4caad6b54844aa63a5faf748b83eecc2dd0d4fb1d913f8de55365

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:46 GMT
content-encoding: gzip
last-modified: Tue, 12 Mar 2019 21:28:44 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: cQRY3VWclXcUrEqOlTV+tQ==
etag: 0x8D6A731B4E44E12
vary: Origin, Accept-Encoding
content-type: application/x-javascript
status: 200
x-ms-request-id: 994697e9-001e-0073-5393-dad706000000
cache-control: max-age=604799
x-ms-version: 2009-09-19
content-length: 29865

GET
H2 200 jsll-4.js Show response
az725175.vo.msecnd.net/scripts/ 54 KB
18 KB 78ms
11ms Script
text/javascript 152.199.19.160
MCI Communication...

General

Check archive.org

Show headers Download Go to

Full URL: https://az725175.vo.msecnd.net/scripts/jsll-4.js
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.3, , AES_256_GCM
Server: 152.199.19.160 Ashburn, United States, ASN15133 (EDGECAST - MCI Communications Services, Inc. d/b/a Verizon Business, US),
Reverse DNS
Software: ECAcc (frc/8F78) /
Resource Hash: e6bbfa4af18fb4f0e9c8a31d6654eac92d0f82dc895c6e5f49b54a8de51e5923

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:45 GMT
content-encoding: gzip
content-md5: Dy7dMa7nsOSUbofNz/X23A==
x-cache: HIT
status: 200
content-length: 18058
x-ms-lease-status: unlocked
last-modified: Thu, 14 Mar 2019 00:43:49 GMT
server: ECAcc (frc/8F78)
etag: 0x8D6A8161FD3B925
vary: Accept-Encoding
content-type: text/javascript; charset="utf-8"
x-ms-request-id: 39b370aa-601e-0035-5091-da617e000000
cache-control: public, max-age=1800, immutable
x-ms-version: 2009-09-19

GET
H2 200 bundle.thread-view.19.3.1.2.min.js Show response
answersstaticfilecdn.azureedge.net/static/js/bundle/ 96 KB
21 KB 635ms
635ms Script
application/x-javascript 2a02:26f0:6c00:287::2ed9
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://answersstaticfilecdn.azureedge.net/static/js/bundle/bundle.thread-view.19.3.1.2.min.js
Requested by: Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:287::2ed9 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: bede4fb137b197ac4c713d1fde2ab6969a878cb98025c9686d165c75527027da

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:45 GMT
content-encoding: gzip
last-modified: Fri, 01 Mar 2019 20:36:23 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: nD/l0qOaZJYoEXe6c8WkbA==
etag: 0x8D69E85919D1D0E
vary: Origin, Accept-Encoding
content-type: application/x-javascript
status: 200
x-ms-request-id: 046fc2f2-601e-0038-2493-da2b55000000
cache-control: max-age=604747
x-ms-version: 2009-09-19
content-length: 21544

GET
H/1.1 200
OK 18-d72213 Show response
statics-uhf-neu.akamaized.net/shell/_scrf/js/themes=default/54-af9f9f/c0-247156/de-099401/e1-a50eee/e7-954872/d8-97d509/f0-251fe2/46-be1318/77-04a268/7f-652c90/63-077520/a4-34de62/75-71ddfc/db-bc01... 125 KB
33 KB 7ms
6ms Script
text/javascript 2a02:26f0:6c00::210:ba22
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://statics-uhf-neu.akamaized.net/shell/_scrf/js/themes=default/54-af9f9f/c0-247156/de-099401/e1-a50eee/e7-954872/d8-97d509/f0-251fe2/46-be1318/77-04a268/7f-652c90/63-077520/a4-34de62/75-71ddfc/db-bc0148/dc-7e9864/78-4c7d22/9f-d154ca/e4-8302f6/cd-23d3b0/6d-1e7ed0/b7-cadaa7/ca-40b7b0/4e-ee3a55/3e-f5c39b/c3-6454d7/f9-7592d3/92-10345d/79-499886/7e-cda2d3/32-6dafa3/93-283c2d/e0-3c9860/91-97a04f/1f-100dea/33-abe4df/18-d72213?ver=2.0&iife=1

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_ECDSA, AES_256_GCM

Server

2a02:26f0:6c00::210:ba22 , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Microsoft-IIS/10.0 /

Resource Hash

55afd02f9ca1fe1b8d3705ef8eba7c9a8e2f0ba4b8d1ab8853a2a10fae9e4ac8

Security Headers

Name	Value
X-Content-Type-Options	nosniff
X-Xss-Protection	1

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

ms-operation-id: 91f3d7fa480248f7ad9f5b90d2f7f338
Date: Thu, 14 Mar 2019 18:28:45 GMT
Content-Encoding: gzip
X-Content-Type-Options: nosniff
X-S2: 2019-02-28T05:22:13
P3P: CP="CAO CONi OTR OUR DEM ONL"
X-Activity-Id: 00000000-60f0-4810-b5da-e530ee7351ae
Connection: keep-alive
MS-CV: /tXFXcnNrkOBvN5y.0
Vary: Accept-Encoding
Content-Length: 33384
X-XSS-Protection: 1
Last-Modified: Thu, 28 Feb 2019 05:22:13 GMT
Server: Microsoft-IIS/10.0
X-Az: {did:-, rid: -, sn: uhf-neu-prod, dt: 2019-02-28T01:37:47.9955527Z, bt: 2019-02-27T00:18:04.0000000Z}
X-S1: 2019-02-28T05:22:13
Access-Control-Allow-Methods: HEAD,GET,POST,PATCH,PUT,OPTIONS
Content-Type: text/javascript; charset=utf-8
Access-Control-Allow-Origin: *
Cache-Control: public, max-age=30279156
Timing-Allow-Origin: *
X-AppVersion: 1.0.6997.542
Expires: Fri, 28 Feb 2020 05:21:21 GMT

GET
H/1.1 200
OK meversion Show response
mem.gfx.ms/ 19 KB
7 KB 7ms
6ms Script
application/javascript 2a02:26f0:6c00:18d::37
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://mem.gfx.ms/meversion?partner=MSAnswers&market=en-us&uhf=1

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

2a02:26f0:6c00:18d::37 , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Resource Hash

903a8ad589e813a28c70faf901779065e232511f07377d393f06b135408b0c81

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

Date: Thu, 14 Mar 2019 18:28:46 GMT
Content-Encoding: gzip
X-Content-Type-Options: nosniff
Vary: Accept-Encoding
Content-Type: application/javascript
Expires: Fri, 15 Mar 2019 15:35:12 GMT
Cache-Control: public, no-transform, max-age=86400
Connection: keep-alive
Content-Length: 6732
X-UA-Compatible: IE=edge

GET
H2 200 mwfmdl2-v2.81.woff2
www.microsoft.com/mwf/_h/v2.81/mwf.app/fonts/ 17 KB
18 KB 184ms
130ms Font
application/font-woff2 2a02:26f0:6c00:187::356e
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://www.microsoft.com/mwf/_h/v2.81/mwf.app/fonts/mwfmdl2-v2.81.woff2

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

2a02:26f0:6c00:187::356e , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Resource Hash

42c8697c004ced79b2c06adf4111db0bda0da08527b97e83f53f4622bca9091b

Security Headers

Name	Value
Strict-Transport-Security	max-age=31536000
X-Content-Type-Options	nosniff
X-Xss-Protection	1

Request headers

:path: /mwf/_h/v2.81/mwf.app/fonts/mwfmdl2-v2.81.woff2
pragma: no-cache
origin: https://answers.microsoft.com
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: */*
cache-control: no-cache
:authority: www.microsoft.com
referer: https://answersstaticfilecdn.azureedge.net/static/css/mwf/bundle/bundle.thread-view-mwfv3.19.3.1.2.min.css
:scheme: https
:method: GET
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Referer: https://answersstaticfilecdn.azureedge.net/static/css/mwf/bundle/bundle.thread-view-mwfv3.19.3.1.2.min.css
Origin: https://answers.microsoft.com

Response headers

x-edgeconnect-origin-mex-latency: 26
date: Thu, 14 Mar 2019 18:28:46 GMT
x-content-type-options: nosniff
x-rtag: RT
x-edgeconnect-midmile-rtt: 79
p3p: CP="CAO CONi OTR OUR DEM ONL"
status: 200
x-activity-id: 5be0cffd-ef0f-47e4-8522-80f64a903b1d
ms-cv: XsVWhgpLCkeHe0gm.0
content-length: 17448
x-xss-protection: 1
last-modified: Sat, 02 Mar 2019 01:11:58 GMT
x-az: {did:ebbeaea41e034f1a8d3657f77961d2e1, rid: 0, sn: mwf-eus-prod, dt: 2019-03-02T01:04:24.2857917Z, bt: 2018-12-01T00:33:22.0000000Z}
strict-transport-security: max-age=31536000
access-control-allow-methods: HEAD,GET,POST,PATCH,PUT,OPTIONS
content-type: application/font-woff2
access-control-allow-origin: *
cache-control: public, max-age=30436992
access-control-allow-headers: *
x-appversion: 1.0.6909.1001
expires: Sun, 01 Mar 2020 01:11:58 GMT

GET
H2 200 latest.woff2
c.s-microsoft.com/static/fonts/segoe-ui/west-european/normal/ 33 KB
34 KB 52ms
6ms Font
application/font-woff2 2a02:26f0:6c00:28b::356e
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://c.s-microsoft.com/static/fonts/segoe-ui/west-european/normal/latest.woff2

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

2a02:26f0:6c00:28b::356e , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Resource Hash

4f7f4afe26e71fa9ca1dac4a43b557a554a46f53251d849f07ed08a04829d74b

Security Headers

Name	Value
X-Frame-Options	SAMEORIGIN

Request headers

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Referer: https://statics-uhf-neu.akamaized.net/west-european/shell/_scrf/css/themes=default.device=uplevel_web_pc/e9-4413b1/4e-bb306d/a9-963a11/10-aee09b/51-465167/1d-9730ee/34-521645/51-6d3a1e?ver=2.0
Origin: https://answers.microsoft.com

Response headers

date: Thu, 14 Mar 2019 18:28:46 GMT
last-modified: Tue, 01 Mar 2016 17:40:35 GMT
access-control-allow-origin: *
etag: "1D173E175B3AB80"
x-frame-options: SAMEORIGIN
access-control-allow-methods: GET,POST
p3p: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
status: 200
cache-control: public, max-age=98709
access-control-allow-credentials: true
accept-ranges: bytes
content-type: application/font-woff2
access-control-allow-headers: Origin, X-Requested-With, Content-Type, Accept
content-length: 34052
expires: Fri, 15 Mar 2019 21:53:55 GMT

GET
H2 200 latest.woff2
c.s-microsoft.com/static/fonts/segoe-ui/west-european/Bold/ 29 KB
30 KB 45ms
11ms Font
application/font-woff2 2a02:26f0:6c00:28b::356e
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://c.s-microsoft.com/static/fonts/segoe-ui/west-european/Bold/latest.woff2

Requested by

Host: answers.microsoft.com
URL: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

2a02:26f0:6c00:28b::356e , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Resource Hash

1232bbdbc5d205f3c5a40efa5ed92839c79e7879d5168445cc47645bb93f7d1b

Security Headers

Name	Value
X-Frame-Options	SAMEORIGIN

Request headers

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Referer: https://statics-uhf-neu.akamaized.net/west-european/shell/_scrf/css/themes=default.device=uplevel_web_pc/e9-4413b1/4e-bb306d/a9-963a11/10-aee09b/51-465167/1d-9730ee/34-521645/51-6d3a1e?ver=2.0
Origin: https://answers.microsoft.com

Response headers

date: Thu, 14 Mar 2019 18:28:46 GMT
last-modified: Tue, 01 Mar 2016 17:40:35 GMT
access-control-allow-origin: *
etag: "1D173E175B3AB80"
x-frame-options: SAMEORIGIN
access-control-allow-methods: GET,POST
p3p: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
status: 200
cache-control: public, max-age=476105
access-control-allow-credentials: true
accept-ranges: bytes
content-type: application/font-woff2
access-control-allow-headers: Origin, X-Requested-With, Content-Type, Accept
content-length: 30132
expires: Wed, 20 Mar 2019 06:43:51 GMT

GET
H/1.1 200
OK Cookie set t.js Show response
web.vortex.data.microsoft.com/collect/v1/ 260 B
909 B 198ms
29ms Script
application/javascript 40.77.226.250
Microsoft Corpora...

General

Check archive.org

Show headers Download Go to

Full URL

https://web.vortex.data.microsoft.com/collect/v1/t.js?ver=%272.1%27&name=%27Ms.Webi.PageView%27&time=%272019-03-14T18%3A28%3A46.394Z%27&os=%27MacOS%27&appId=%27JS%3Aanswers.microsoft.com%27&-ver=%271.0%27&-impressionGuid=%273d9fa1df-6cb2-4a7c-a0c1-877c0b664783%27&-pageName=%27ViewThread%27&-uri=%27https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2007-excel%2Fcountif-one-column-based-on-values-of-another%2F16acea3b-1f22-49ed-9ba8-32975445de83%27&-resHeight=1200&-resWidth=1600&-pageTags=%27%7B%22metaTags%22%3A%7B%22loc%22%3A%22us%22%2C%22lang%22%3A%22en%22%2C%22srchq%22%3A%22%22%2C%22communityUserId%22%3A%22%22%2C%22flightNames%22%3A%22smc-survey-feat-1%7Csmc-survey-elg-1%7Cvafx-intro-0%7Cfilterexposuretest%7Cce-aatest-0%7Csmc-clicktale%7Cvafx-uc-1%7Cvafx-pip-1%7Cvasf-af-1%7Cvafx-sgst2-1%7Cvafx-snt-1%7Ccf-cx12-1%7Cvafx-icsv21-1%7Ccs-vacontent1-0%22%2C%22cookieconsentrequired%22%3A%22true%22%2C%22server%22%3A%22DBDD%22%2C%22serverDC%22%3A%22DB5%22%2C%22environment%22%3A%22prod%22%2C%22muid%22%3A%22169D1550AE2260882462184FAF896152%22%2C%22isTopContent%22%3A%22false%22%2C%22threadAnswered%22%3A%22true%22%2C%22threadType%22%3A%22qna%22%2C%22threadId%22%3A%2216acea3b-1f22-49ed-9ba8-32975445de83%22%2C%22viewCount%22%3A%2232587%22%2C%22threadForumName%22%3A%22msoffice%22%7D%7D%27&-behavior=0&*baseType=%27Ms.Content.PageView%27&*cookieEnabled=true&*isJs=true&*title=%27countif%20one%20column%20based%20on%20values%20of%20another%20-%20Microsoft%20Community%27&*isLoggedIn=false&*flashInstalled=false&ext-javascript-ver=%271.1%27&ext-javascript-libVer=%274.2.14%27&ext-javascript-domain=%27answers.microsoft.com%27&ext-javascript-userConsent=false&$mscomCookies=false

Requested by

Host: az725175.vo.msecnd.net
URL: https://az725175.vo.msecnd.net/scripts/jsll-4.js

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_128_GCM

Server

40.77.226.250 Dublin, Ireland, ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US),

Reverse DNS

Software

Resource Hash

ffdba3ef37e47d3b286316be187878a4014f24186d8deee9d2de70728aee6f24

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Pragma: no-cache
Accept-Encoding: gzip, deflate, br
Host: web.vortex.data.microsoft.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Accept: */*
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Connection: keep-alive
Cache-Control: no-cache
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

Pragma: no-cache
Date: Thu, 14 Mar 2019 18:28:46 GMT
X-Content-Type-Options: nosniff
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
Cache-Control: no-cache, no-store
Set-Cookie: MC1=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571; Domain=.microsoft.com; Expires=Fri, 13 Mar 2020 18:28:46 GMT; Path=/ MS0=689cb8865900438ba67d5fc9bd53a3a6; Domain=.microsoft.com; Expires=Thu, 14 Mar 2019 18:58:46 GMT; Path=/
MS-CV: F1yfAUkt6U2e6ew9oWBPhg.0
Content-Type: application/javascript
Content-Length: 260
Expires: 0

GET
H/1.1 200
OK meBoot.min.js Show response
mem.gfx.ms/me/MeControl/10.19058.0/en-US/ 96 KB
25 KB 87ms
86ms Script
application/javascript 2a02:26f0:6c00:18d::37
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://mem.gfx.ms/me/MeControl/10.19058.0/en-US/meBoot.min.js

Requested by

Host: mem.gfx.ms
URL: https://mem.gfx.ms/meversion?partner=MSAnswers&market=en-us&uhf=1

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

2a02:26f0:6c00:18d::37 , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Resource Hash

4c10ce0f44caa90b5fac03700c2a7f2e52881b337f79332c4b29b604f7e3a361

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

Date: Thu, 14 Mar 2019 18:28:46 GMT
Content-Encoding: gzip
X-Content-Type-Options: nosniff
Last-Modified: Thu, 28 Feb 2019 00:53:13 GMT
Vary: Accept-Encoding
Content-Type: application/javascript
Cache-Control: max-age=2592000
Connection: keep-alive
Accept-Ranges: bytes
Content-Length: 25481
X-UA-Compatible: IE=edge

GET
DATA 200
OK truncated
/ 360 B
0 Image
image/svg+xml

General

Check archive.org

Show headers Download Go to Show image

Full URL: data:truncated
Protocol: DATA
Server: -, , ASN (),
Reverse DNS
Software: /
Resource Hash: 593dbe4f1db37a6da9d5f732bc4bb17eb419e2c9e42bd4b3d897bca85fa131b2

Request headers

Response headers

Content-Type: image/svg+xml;charset=utf-8

GET
H2 200 mwf-main.var.1.53.1.min.js Show response
answersstaticfilecdn.azureedge.net/static/js/mwf/ 340 KB
82 KB 367ms
367ms Script
application/x-javascript 2a02:26f0:6c00:287::2ed9
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://answersstaticfilecdn.azureedge.net/static/js/mwf/mwf-main.var.1.53.1.min.js
Requested by: Host: answersstaticfilecdn.azureedge.net
URL: https://answersstaticfilecdn.azureedge.net/static/js/lib/jquery/jquery-2.2.4.min.js
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:287::2ed9 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: 6cf921cf7bd161d84348d6b5759cbffac4255e9df3c631031543d40e06a4f70c

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:46 GMT
content-encoding: gzip
last-modified: Tue, 12 Mar 2019 21:28:45 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: 4pYmvNLXrhTrsBU7eeCXhA==
etag: 0x8D6A731B4EF257B
vary: Origin, Accept-Encoding
content-type: application/x-javascript
status: 200
x-ms-request-id: 99469b04-001e-0073-2793-dad706000000
cache-control: max-age=604800
x-ms-version: 2009-09-19

GET
H2 200 mscc-0.4.1.min.js Show response
uhf.microsoft.com/mscc/statics/ 3 KB
2 KB 11ms
9ms Script
text/javascript 2a02:26f0:6c00:286::2b57
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL: https://uhf.microsoft.com/mscc/statics/mscc-0.4.1.min.js
Requested by: Host: answersstaticfilecdn.azureedge.net
URL: https://answersstaticfilecdn.azureedge.net/static/js/lib/jquery/jquery-2.2.4.min.js
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:286::2b57 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0 /
Resource Hash: c87516d7dd7077edd467f5b7b085b035cd4803ecf049670ab19de004e270aba8

Request headers

:path: /mscc/statics/mscc-0.4.1.min.js
pragma: no-cache
cookie: MC1=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571; MS0=689cb8865900438ba67d5fc9bd53a3a6
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: */*
cache-control: no-cache
:authority: uhf.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

x-ms-lease-status: unlocked
x-ms-blob-type: BlockBlob
date: Thu, 14 Mar 2019 18:28:46 GMT
content-encoding: gzip
last-modified: Mon, 10 Sep 2018 17:42:12 GMT
server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
content-md5: XpofSqMdSqYPb4maLkXO+A==
status: 200
etag: 0x8D61744BD6EA9B6
vary: Accept-Encoding
content-type: text/javascript;charset=utf-8
access-control-allow-origin: *
x-ms-request-id: 5049127a-701e-0074-2afe-4995de000000
x-ms-version: 2009-09-19
content-length: 1588

GET
H2 200 addthreadviewcountasync
answers.microsoft.com/en-us/contentstatisticsspark/ 807 B
1 KB 53ms
52ms Image
image/gif 184.31.82.138
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to Show image

Full URL

https://answers.microsoft.com/en-us/contentstatisticsspark/addthreadviewcountasync?id=16acea3b-1f22-49ed-9ba8-32975445de83&forum=ab4ca1d1-17e8-4a3a-9d1f-bbe19625f3a9

Protocol

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

184.31.82.138 Amsterdam, Netherlands, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

a184-31-82-138.deploy.static.akamaitechnologies.com

Software

Resource Hash

9c6d485ae01a594ef22b3c44e1eca5314259061faacdcdfc51569aba58a4fc2b

Security Headers

Name	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff

Request headers

:path: /en-us/contentstatisticsspark/addthreadviewcountasync?id=16acea3b-1f22-49ed-9ba8-32975445de83&forum=ab4ca1d1-17e8-4a3a-9d1f-bbe19625f3a9
pragma: no-cache
cookie: cap_f=smc-survey-feat-1|smc-survey-elg-1|vafx-intro-0|filterexposuretest|ce-aatest-0|smc-clicktale|vafx-uc-1|vafx-pip-1|vasf-af-1|vafx-sgst2-1|vafx-snt-1|cf-cx12-1|vafx-icsv21-1|cs-vacontent1-0; cap_t=2019-03-14T18:28:44.8014933Z; asid=f7bc4b7d-f5b8-49c7-8036-c345f02b6c86; MC1=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571; MS0=689cb8865900438ba67d5fc9bd53a3a6; MSFPC=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: image/webp,image/apng,image/*,*/*;q=0.8
cache-control: no-cache
:authority: answers.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

pragma: no-cache
date: Thu, 14 Mar 2019 18:28:46 GMT
x-content-type-options: nosniff
server
strict-transport-security: max-age=86400 ; includeSubDomains
content-type: image/gif
status: 200
cache-control: max-age=0, no-cache, no-store no-transform
x-ua-compatible: IE=edge
content-disposition: attachment; filename=PageStatistics.gif
set-cookie: cap_t=2019-03-14T18:28:46.6295907Z; domain=answers.microsoft.com; path=/
ms-cv: Q1Cco3mC7EeSkSXYf9VZPw.0
content-length: 807
expires: Thu, 14 Mar 2019 18:28:46 GMT

GET
H/1.1 200
OK Cookie set me.srf
login.live.com/ Frame 0FBF 0
0 578ms
112ms Document
text/html 2a01:111:2010:6::ff16
Microsoft Corpora...

General

Check archive.org

Show headers Download Go to

Full URL

https://login.live.com/me.srf?wa=wsignin1.0&wreply=https%3A%2F%2Fanswers.microsoft.com&uaid=af62fb3b-cbc8-4ea0-3575-8a3803cbec52&partnerId=msanswers

Requested by

Host: mem.gfx.ms
URL: https://mem.gfx.ms/me/MeControl/10.19058.0/en-US/meBoot.min.js

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_256_CBC

Server

2a01:111:2010:6::ff16 , United Kingdom, ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US),

Reverse DNS

Software

Microsoft-IIS/8.5 /

Resource Hash

Security Headers

Name	Value
Strict-Transport-Security	max-age=31536000
X-Content-Type-Options	nosniff
X-Xss-Protection	1; mode=block

Request headers

Host: login.live.com
Connection: keep-alive
Pragma: no-cache
Cache-Control: no-cache
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Accept-Encoding: gzip, deflate, br
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83

Response headers

Cache-Control: no-cache, no-store
Pragma: no-cache
Content-Type: text/html; charset=utf-8
Content-Encoding: gzip
Expires: Thu, 14 Mar 2019 18:27:47 GMT
Vary: Accept-Encoding
Server: Microsoft-IIS/8.5
P3P: CP="DSP CUR OTPi IND OTRi ONL FIN"
Set-Cookie: uaid=af62fb3bcbc84ea035758a3803cbec52; domain=login.live.com;secure= ;path=/;HTTPOnly= ;version=1 MSPRequ=lt=1552588127&co=1&id=N; secure= ;path=/;HTTPOnly=;version=1
PPServer: PPV: 30 H: BL2IDSLGN1E030 V: 0
X-Content-Type-Options: nosniff
Strict-Transport-Security: max-age=31536000
X-XSS-Protection: 1; mode=block
Date: Thu, 14 Mar 2019 18:28:46 GMT
Content-Length: 3981

GET
H/1.1 200
OK meCore.min.js Show response
mem.gfx.ms/me/MeControl/10.19058.0/en-US/ 56 KB
12 KB 51ms
50ms Script
application/javascript 2a02:26f0:6c00:18d::37
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to

Full URL

https://mem.gfx.ms/me/MeControl/10.19058.0/en-US/meCore.min.js

Requested by

Host: mem.gfx.ms
URL: https://mem.gfx.ms/meversion?partner=MSAnswers&market=en-us&uhf=1

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_256_GCM

Server

2a02:26f0:6c00:18d::37 , European Union, ASN20940 (AKAMAI-ASN1, US),

Reverse DNS

Software

Resource Hash

78a0e251c092391764a7567fed67dd42573fdded8b48d158e2d3275fafe6cca3

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

Date: Thu, 14 Mar 2019 18:28:46 GMT
Content-Encoding: gzip
X-Content-Type-Options: nosniff
Last-Modified: Thu, 28 Feb 2019 00:53:13 GMT
Vary: Accept-Encoding
Content-Type: application/javascript
Cache-Control: max-age=2592000
Connection: keep-alive
Accept-Ranges: bytes
Content-Length: 11765
X-UA-Compatible: IE=edge

POST
H/1.1 200
OK v1
web.vortex.data.microsoft.com/collect/ 57 B
668 B 30ms
28ms Other
application/json 40.77.226.250
Microsoft Corpora...

General

Check archive.org

Show headers Download Go to

Full URL

https://web.vortex.data.microsoft.com/collect/v1?$mscomCookies=false&ext-javascript-msfpc=%27GUID%3D2674130545f64f8aaec710de3df38164%26HASH%3D2674%26LV%3D201903%26V%3D4%26LU%3D1552588126571%27

Requested by

Host: az725175.vo.msecnd.net
URL: https://az725175.vo.msecnd.net/scripts/jsll-4.js

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_128_GCM

Server

40.77.226.250 Dublin, Ireland, ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US),

Reverse DNS

Software

Resource Hash

8d316e9191d40a4b9cc775c0adce0a999873c1935781d1312a5b12ee717c53d4

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Pragma: no-cache
Origin: https://answers.microsoft.com
Accept-Encoding: gzip, deflate, br
Host: web.vortex.data.microsoft.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Content-Type: text/plain;charset=UTF-8
Accept: */*
Cache-Control: no-cache
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Cookie: MC1=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571; MS0=689cb8865900438ba67d5fc9bd53a3a6
Connection: keep-alive
Content-Length: 7644
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Origin: https://answers.microsoft.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Content-Type: text/plain;charset=UTF-8

Response headers

Pragma: no-cache
Date: Thu, 14 Mar 2019 18:28:46 GMT
X-Content-Type-Options: nosniff
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
Access-Control-Allow-Origin: https://answers.microsoft.com
Cache-Control: no-cache, no-store
Access-Control-Allow-Credentials: true
MS-CV: 9+Zeh5E3ik6AhleEGWutnw.0
Content-Type: application/json
Access-Control-Allow-Headers: Accept, Authorization, Content-Type, Origin, X-Xbl-Contract-Version, X-Xbl-Device-Type, Xbl-Authz-Actor-10, WithCredentials
Content-Length: 57
Expires: 0

GET
H2 204 _log
uhf.microsoft.com/ 0
128 B 7ms
6ms Image
text/html 2a02:26f0:6c00:286::2b57
AKAMAI-ASN1

General

Check archive.org

Show headers Download Go to Show image

Full URL: https://uhf.microsoft.com/_log?o=mscc&s=answers.microsoft.com&m=show&nv=aspnet-3.0.0&sv=0.1.2
Protocol: H2
Security: TLS 1.2, ECDHE_RSA, AES_256_GCM
Server: 2a02:26f0:6c00:286::2b57 , European Union, ASN20940 (AKAMAI-ASN1, US),
Reverse DNS
Software: /
Resource Hash: e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

Request headers

:path: /_log?o=mscc&s=answers.microsoft.com&m=show&nv=aspnet-3.0.0&sv=0.1.2
pragma: no-cache
cookie: MC1=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571; MS0=689cb8865900438ba67d5fc9bd53a3a6
accept-encoding: gzip, deflate, br
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
accept: image/webp,image/apng,image/*,*/*;q=0.8
cache-control: no-cache
:authority: uhf.microsoft.com
referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
:scheme: https
:method: GET
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

pragma: no-cache
date: Thu, 14 Mar 2019 18:28:46 GMT
status: 204
content-type: text/html
access-control-allow-origin: *
cache-control: max-age=0, no-cache, no-store
content-length: 0
expires: Thu, 14 Mar 2019 18:28:46 GMT

POST
H/1.1 200
OK v1
web.vortex.data.microsoft.com/collect/ 57 B
668 B 29ms
29ms Other
application/json 40.77.226.250
Microsoft Corpora...

General

Check archive.org

Show headers Download Go to

Full URL

https://web.vortex.data.microsoft.com/collect/v1?$mscomCookies=false&ext-javascript-msfpc=%27GUID%3D2674130545f64f8aaec710de3df38164%26HASH%3D2674%26LV%3D201903%26V%3D4%26LU%3D1552588126571%27

Requested by

Host: az725175.vo.msecnd.net
URL: https://az725175.vo.msecnd.net/scripts/jsll-4.js

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_128_GCM

Server

40.77.226.250 Dublin, Ireland, ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US),

Reverse DNS

Software

Resource Hash

5fdac9339e100fe7d9bb2dd1e23ead50c0181543dccf02f14ad4fd350ab3dc75

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Pragma: no-cache
Origin: https://answers.microsoft.com
Accept-Encoding: gzip, deflate, br
Host: web.vortex.data.microsoft.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Content-Type: text/plain;charset=UTF-8
Accept: */*
Cache-Control: no-cache
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Cookie: MC1=GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571; MS0=689cb8865900438ba67d5fc9bd53a3a6
Connection: keep-alive
Content-Length: 7700
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Origin: https://answers.microsoft.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Content-Type: text/plain;charset=UTF-8

Response headers

Pragma: no-cache
Date: Thu, 14 Mar 2019 18:28:46 GMT
X-Content-Type-Options: nosniff
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
Access-Control-Allow-Origin: https://answers.microsoft.com
Cache-Control: no-cache, no-store
Access-Control-Allow-Credentials: true
MS-CV: 1rOI6TNYzEqTB4IsAnr95g.0
Content-Type: application/json
Access-Control-Allow-Headers: Accept, Authorization, Content-Type, Origin, X-Xbl-Contract-Version, X-Xbl-Device-Type, Xbl-Authz-Actor-10, WithCredentials
Content-Length: 57
Expires: 0

GET
H/1.1 200
OK Cookie set t.js Show response
web.vortex.data.microsoft.com/collect/v1/ 260 B
909 B 29ms
28ms Script
application/javascript 40.77.226.250
Microsoft Corpora...

General

Check archive.org

Show headers Download Go to

Full URL

https://web.vortex.data.microsoft.com/collect/v1/t.js?ver=%272.1%27&name=%27Ms.Webi.PageAction%27&time=%272019-03-14T18%3A28%3A54.423Z%27&os=%27MacOS%27&appId=%27JS%3Aanswers.microsoft.com%27&cV=%27nweyMJpGmqsA8r9AkCZkQu.2%27&-ver=%271.0%27&-impressionGuid=%273d9fa1df-6cb2-4a7c-a0c1-877c0b664783%27&-pageName=%27ViewThread%27&-uri=%27https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2007-excel%2Fcountif-one-column-based-on-values-of-another%2F16acea3b-1f22-49ed-9ba8-32975445de83%27&-pageTags=%27%7B%22metaTags%22%3A%7B%22loc%22%3A%22us%22%2C%22lang%22%3A%22en%22%2C%22srchq%22%3A%22%22%2C%22communityUserId%22%3A%22%22%2C%22flightNames%22%3A%22smc-survey-feat-1%7Csmc-survey-elg-1%7Cvafx-intro-0%7Cfilterexposuretest%7Cce-aatest-0%7Csmc-clicktale%7Cvafx-uc-1%7Cvafx-pip-1%7Cvasf-af-1%7Cvafx-sgst2-1%7Cvafx-snt-1%7Ccf-cx12-1%7Cvafx-icsv21-1%7Ccs-vacontent1-0%22%2C%22cookieconsentrequired%22%3A%22true%22%2C%22server%22%3A%22DBDD%22%2C%22serverDC%22%3A%22DB5%22%2C%22environment%22%3A%22prod%22%2C%22muid%22%3A%22169D1550AE2260882462184FAF896152%22%2C%22isTopContent%22%3A%22false%22%2C%22threadAnswered%22%3A%22true%22%2C%22threadType%22%3A%22qna%22%2C%22threadId%22%3A%2216acea3b-1f22-49ed-9ba8-32975445de83%22%2C%22viewCount%22%3A%2232587%22%2C%22threadForumName%22%3A%22msoffice%22%7D%7D%27&-contentVer=%272.0%27&-behavior=0&-content=%27%5B%7B%22contentId%22%3A%22no-bounce%22%2C%22contentName%22%3A%22no-bounce%22%7D%5D%27&*baseType=%27Ms.Content.PageAction%27&*timeToAction=9812&*cookieEnabled=true&*isJs=true&*title=%27countif%20one%20column%20based%20on%20values%20of%20another%20-%20Microsoft%20Community%27&*isLoggedIn=false&*isManual=true&ext-javascript-ver=%271.1%27&ext-javascript-libVer=%274.2.14%27&ext-javascript-domain=%27answers.microsoft.com%27&ext-javascript-userConsent=false&$mscomCookies=false

Requested by

Host: az725175.vo.msecnd.net
URL: https://az725175.vo.msecnd.net/scripts/jsll-4.js

Protocol

HTTP/1.1

Security

TLS 1.2, ECDHE_RSA, AES_128_GCM

Server

40.77.226.250 Dublin, Ireland, ASN8075 (MICROSOFT-CORP-MSN-AS-BLOCK - Microsoft Corporation, US),

Reverse DNS

Software

Resource Hash

5510c4b4f26f5b7540302b4b9ec29d29324d672f2649997d7056d7e736d06f20

Security Headers

Name	Value
X-Content-Type-Options	nosniff

Request headers

Pragma: no-cache
Accept-Encoding: gzip, deflate, br
Host: web.vortex.data.microsoft.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Accept: */*
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
Connection: keep-alive
Cache-Control: no-cache
Referer: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/countif-one-column-based-on-values-of-another/16acea3b-1f22-49ed-9ba8-32975445de83
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Response headers

Pragma: no-cache
Date: Thu, 14 Mar 2019 18:28:54 GMT
X-Content-Type-Options: nosniff
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
Cache-Control: no-cache, no-store
Set-Cookie: MC1=GUID=83e570351e764366bed047581df9b21b&HASH=83e5&LV=201903&V=4&LU=1552588134430; Domain=.microsoft.com; Expires=Fri, 13 Mar 2020 18:28:54 GMT; Path=/ MS0=f0b8f7bea8a64ae085412a2a76bbec2d; Domain=.microsoft.com; Expires=Thu, 14 Mar 2019 18:58:54 GMT; Path=/
MS-CV: gPFO8wsDH0uc94+uuzc0jw.0
Content-Type: application/javascript
Content-Length: 260
Expires: 0

Verdicts & Comments Add Verdict or Comment

63 JavaScript Global Variables

These are the non-standard "global" variables defined on the window object. These can be helpful in identifying possible client-side frameworks and code.

6 Cookies

Cookies are little pieces of information stored in the browser of a user. Whenever a user visits the site again, he will also send his cookie values, thus allowing the website to re-identify him even if he changed locations. This is how permanent logins work.

Domain/Path	Expires	Name / Value
answers.microsoft.com/	1970-01-19 08:02:04	Name: MSFPC Value: GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571
.answers.microsoft.com/	1969-12-31 23:59:59	Name: cap_t Value: 2019-03-14T18:28:44.8014933Z
.microsoft.com/	1970-01-18 23:16:29	Name: MS0 Value: 689cb8865900438ba67d5fc9bd53a3a6
.answers.microsoft.com/	1969-12-31 23:59:59	Name: asid Value: f7bc4b7d-f5b8-49c7-8036-c345f02b6c86
.microsoft.com/	1970-01-19 08:02:04	Name: MC1 Value: GUID=2674130545f64f8aaec710de3df38164&HASH=2674&LV=201903&V=4&LU=1552588126571
.answers.microsoft.com/	1969-12-31 23:59:59	Name: cap_f Value: smc-survey-feat-1\|smc-survey-elg-1\|vafx-intro-0\|filterexposuretest\|ce-aatest-0\|smc-clicktale\|vafx-uc-1\|vafx-pip-1\|vasf-af-1\|vafx-sgst2-1\|vafx-snt-1\|cf-cx12-1\|vafx-icsv21-1\|cs-vacontent1-0

Security Headers

This page lists any security headers set by the main page. If you want to understand what these mean and how to use them, head on over to this page

Header	Value
Strict-Transport-Security	max-age=86400 ; includeSubDomains
X-Content-Type-Options	nosniff
X-Frame-Options	SAMEORIGIN

Indicators

This is a term in the security industry to describe indicators such as IPs, Domains, Hashes, etc. This does not imply that any of these indicate malicious activity.

answers.microsoft.com
answersstaticfilecdn.azureedge.net
az725175.vo.msecnd.net
c.s-microsoft.com
filestore.community.support.microsoft.com
img-prod-cms-rt-microsoft-com.akamaized.net
login.live.com
mem.gfx.ms
statics-uhf-neu.akamaized.net
uhf.microsoft.com
web.vortex.data.microsoft.com
www.microsoft.com
152.199.19.160
184.31.82.138
2a01:111:2010:6::ff16
2a02:26f0:6c00:187::356e
2a02:26f0:6c00:18d::37
2a02:26f0:6c00:286::2b57
2a02:26f0:6c00:287::2ed9
2a02:26f0:6c00:28b::356e
2a02:26f0:6c00::210:ba1b
2a02:26f0:6c00::210:ba22
40.77.226.250
52.178.161.50
0bd288d5397a69ead391875b422bf2cbdcc4f795d64aa2f780aff45768d78248
112fec798b78aa02e102a724b5cb1990c0f909bc1d8b7b1fa256eab41bbc0960
1232bbdbc5d205f3c5a40efa5ed92839c79e7879d5168445cc47645bb93f7d1b
35211f76c4c35c17f2649b96868c0d691f1d78b107f7635d22619948d0ee6880
390294afcf673c3a5c5e9dc93115f4a17adc218bf1503682505bce03ce9337fb
3abc05cf7fcd206115a9f2871547be6a8649c34b2efc0d1f77441147a5a78bc8
41ab929756123c1ec0a9f778fc98429de6ed7b33b0dda0876816c6c21a8c91f8
42c8697c004ced79b2c06adf4111db0bda0da08527b97e83f53f4622bca9091b
4c10ce0f44caa90b5fac03700c2a7f2e52881b337f79332c4b29b604f7e3a361
4f7f4afe26e71fa9ca1dac4a43b557a554a46f53251d849f07ed08a04829d74b
5510c4b4f26f5b7540302b4b9ec29d29324d672f2649997d7056d7e736d06f20
55afd02f9ca1fe1b8d3705ef8eba7c9a8e2f0ba4b8d1ab8853a2a10fae9e4ac8
593dbe4f1db37a6da9d5f732bc4bb17eb419e2c9e42bd4b3d897bca85fa131b2
5fdac9339e100fe7d9bb2dd1e23ead50c0181543dccf02f14ad4fd350ab3dc75
6a675876939fd5caf91a821c09beb43c2a8aa575223dccc2edfb3ce2e22f527c
6cf921cf7bd161d84348d6b5759cbffac4255e9df3c631031543d40e06a4f70c
78a0e251c092391764a7567fed67dd42573fdded8b48d158e2d3275fafe6cca3
8d316e9191d40a4b9cc775c0adce0a999873c1935781d1312a5b12ee717c53d4
903a8ad589e813a28c70faf901779065e232511f07377d393f06b135408b0c81
9c6d485ae01a594ef22b3c44e1eca5314259061faacdcdfc51569aba58a4fc2b
b409c14a10b4caad6b54844aa63a5faf748b83eecc2dd0d4fb1d913f8de55365
bede4fb137b197ac4c713d1fde2ab6969a878cb98025c9686d165c75527027da
c87516d7dd7077edd467f5b7b085b035cd4803ecf049670ab19de004e270aba8
d2d62af2146363f87ae1fc1ced79018db60c952b3ebd6bf2a38264adac19e864
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
e6bbfa4af18fb4f0e9c8a31d6654eac92d0f82dc895c6e5f49b54a8de51e5923
ed993dd6f4ddfc4efc32560dc921332452c1f9ff46b0758964e8e8b035a94c58
f2e824b33fc5f37acd5f8bc38ba6f41b9fd9425724820ba5cd9aecad3e2b3c0c
fda883eb2047febd0aaefab176e96e41de0faac258a0ba752456476aab9eab5b
ffdba3ef37e47d3b286316be187878a4014f24186d8deee9d2de70728aee6f24

answers.microsoft.com Open in urlscan Pro 184.31.82.138 Public Scan

Summary

urlscan.io Verdict: No classification

Domain & IP information

Screenshot Live screenshot Full Image

Detected technologies

Page Statistics

31 Requests

100 %HTTPS

67 %IPv6

7 Domains

12 Subdomains

13 IPs

5 Countries

614 kBTransfer

2641 kBSize

6 Cookies

84 Outgoing links

Redirected requests

31 HTTP transactions Everything HTML Script AJAX CSS Image Expand all 1 data transactions

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

Request headers

Response headers

answers.microsoft.com Open in urlscan Pro
184.31.82.138 Public Scan

Screenshot
Live screenshot

Full Image

31
Requests

100 %
HTTPS

67 %
IPv6

7
Domains

12
Subdomains

13
IPs

5
Countries

614 kB
Transfer

2641 kB
Size

6
Cookies

31 HTTP transactions
1 data transactions