Submitted URL: http://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Effective URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Submission: On March 09 via manual from US

Summary

This website contacted 24 IPs in 6 countries across 21 domains to perform 96 HTTP transactions. The main IP is 2600:3c00::f03c:91ff:fee7:ea6e, located in United States and belongs to LINODE-AP Linode, LLC, US. The main domain is exceljet.net.
TLS certificate: Issued by Let's Encrypt Authority X3 on February 23rd 2020. Valid for: 3 months.
This is the only time exceljet.net was scanned on urlscan.io!

urlscan.io Verdict: No classification

Domain & IP information

IP Address AS Autonomous System
1 35 2600:3c00::f0... 63949 (LINODE-AP...)
3 2a00:1450:400... 15169 (GOOGLE)
2 2a00:1450:400... 15169 (GOOGLE)
5 52.222.153.241 16509 (AMAZON-02)
4 2a00:1450:400... 15169 (GOOGLE)
1 37.252.173.38 29990 (ASN-APPNEX)
1 18.197.186.176 16509 (AMAZON-02)
1 185.64.189.112 62713 (AS-PUBMATIC)
1 2 52.94.216.48 16509 (AMAZON-02)
5 2a00:1450:400... 15169 (GOOGLE)
2 2a00:1450:400... 15169 (GOOGLE)
4 172.217.23.130 15169 (GOOGLE)
4 2a00:1450:400... 15169 (GOOGLE)
11 185.220.204.204 41436 (CLOUDWEBM...)
1 2 52.73.223.232 14618 (AMAZON-AES)
9 185.127.16.51 210329 (CLOUDWEBM...)
1 3.126.20.131 16509 (AMAZON-02)
2 2 3.248.119.92 16509 (AMAZON-02)
3 3 52.57.106.47 16509 (AMAZON-02)
1 3 18.156.0.31 16509 (AMAZON-02)
2 2 151.101.114.49 54113 (FASTLY)
1 1 52.0.180.19 14618 (AMAZON-AES)
1 35.168.89.112 14618 (AMAZON-AES)
1 2a00:1288:110... 34010 (YAHOO-IRD)
2 2 216.58.210.2 15169 (GOOGLE)
1 23.210.249.92 16625 (AKAMAI-AS)
1 23.210.249.83 16625 (AKAMAI-AS)
2 2 54.93.38.91 16509 (AMAZON-02)
1 1 52.59.36.197 16509 (AMAZON-02)
1 52.57.255.4 16509 (AMAZON-02)
96 24
Domain Requested by
35 exceljet.net 1 redirects exceljet.net
11 live.sekindo.com securepubads.g.doubleclick.net
live.sekindo.com
9 video.sekindo.com live.sekindo.com
exceljet.net
5 c.amazon-adsystem.com exceljet.net
c.amazon-adsystem.com
live.sekindo.com
4 tpc.googlesyndication.com securepubads.g.doubleclick.net
tpc.googlesyndication.com
4 securepubads.g.doubleclick.net www.googletagservices.com
securepubads.g.doubleclick.net
exceljet.net
4 fonts.gstatic.com exceljet.net
3 ups.analytics.yahoo.com 1 redirects
3 pixel.advertising.com 3 redirects
3 www.googletagservices.com exceljet.net
securepubads.g.doubleclick.net
3 fonts.googleapis.com exceljet.net
live.sekindo.com
2 x.bidswitch.net 2 redirects
2 cm.g.doubleclick.net 2 redirects
2 sync-tm.everesttech.net 2 redirects
2 match.adsrvr.org 2 redirects
2 pagead2.googlesyndication.com securepubads.g.doubleclick.net
2 aax-eu.amazon-adsystem.com 1 redirects c.amazon-adsystem.com
2 www.google-analytics.com exceljet.net
1 staging-aws-fr.bidswitch.net
1 bsw.digitru.st 1 redirects
1 acdn.adnxs.com exceljet.net
1 ads.pubmatic.com exceljet.net
1 pr-bh.ybp.yahoo.com
1 sync.adaptv.advertising.com
1 sync.adap.tv 1 redirects
1 ads.adaptv.advertising.com live.sekindo.com
1 ipds.adrta.com exceljet.net
1 adrta.com 1 redirects
1 adservice.google.com www.googletagservices.com
1 adservice.google.de www.googletagservices.com
1 hbopenbid.pubmatic.com exceljet.net
1 grid.bidswitch.net exceljet.net
1 ib.adnxs.com exceljet.net
96 33

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

Domain
twitter.com
Subject Issuer Validity Valid
exceljet.net
Let's Encrypt Authority X3
2020-02-23 -
2020-05-23
3 months crt.sh
*.storage.googleapis.com
GTS CA 1O1
2020-02-12 -
2020-05-06
3 months crt.sh
*.google-analytics.com
GTS CA 1O1
2020-02-12 -
2020-05-06
3 months crt.sh
c.amazon-adsystem.com
Amazon
2019-10-07 -
2020-09-29
a year crt.sh
*.google.com
GTS CA 1O1
2020-02-12 -
2020-05-06
3 months crt.sh
*.adnxs.com
DigiCert ECC Secure Server CA
2019-01-23 -
2021-03-08
2 years crt.sh
grid.bidswitch.net
COMODO RSA Domain Validation Secure Server CA
2018-10-24 -
2020-10-23
2 years crt.sh
*.pubmatic.com
Sectigo RSA Organization Validation Secure Server CA
2019-02-22 -
2021-02-21
2 years crt.sh
aax-eu.amazon-adsystem.com
Amazon
2019-09-18 -
2020-08-26
a year crt.sh
*.g.doubleclick.net
GTS CA 1O1
2020-02-12 -
2020-05-06
3 months crt.sh
tpc.googlesyndication.com
GTS CA 1O1
2020-02-12 -
2020-05-06
3 months crt.sh
www.sekindo.com
Go Daddy Secure Certificate Authority - G2
2019-05-23 -
2020-06-18
a year crt.sh
*.adrta.com
COMODO RSA Domain Validation Secure Server CA
2018-09-01 -
2020-08-31
2 years crt.sh
*.vssp.yahoo.com
DigiCert SHA2 High Assurance Server CA
2019-11-07 -
2020-05-05
6 months crt.sh
ups.analytics.yahoo.com
DigiCert SHA2 High Assurance Server CA
2020-02-13 -
2020-08-11
6 months crt.sh
*.ybp.yahoo.com
DigiCert SHA2 High Assurance Server CA
2020-01-04 -
2020-07-02
6 months crt.sh
cdn.adnxs.com
GeoTrust RSA CA 2018
2020-01-02 -
2021-04-02
a year crt.sh
*.bidswitch.net
Sectigo RSA Domain Validation Secure Server CA
2019-04-17 -
2020-05-04
a year crt.sh

This page contains 9 frames:

Primary Page: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Frame ID: 9AB53F39805B1699BF633203CE49F5AA
Requests: 59 HTTP requests in this frame

Frame: https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx&dcc=t
Frame ID: AF8E084910ABADAF947C9A0754540BC4
Requests: 1 HTTP requests in this frame

Frame: https://tpc.googlesyndication.com/safeframe/1-0-37/html/container.html
Frame ID: F60FF0E13815C579C26B63842785E94F
Requests: 1 HTTP requests in this frame

Frame: https://securepubads.g.doubleclick.net/pcs/view?xai=AKAOjssnB-Kx6agj4WeS8ATEB4Tp-Zh4kH-buVpjPluvmJ6DFpUfkLkvBVOM5kFmdct_HixjGOwD7C0_nybNjWvRuY_Bkt85zW8j3cWRXiWVY6uVIAvSFQvCv6KUpZOa3IqpU5jElwpoNFb3StTSTjqmaIu6JDO2oj4aDpqIc3ceaW1dgG2RDz7ASypM-lITKztXtXsTDiFcpHTZSIIgVKzZqsn-KYtmS6E-0LIugozAq0hghg8Ov60qwyYxIpXPr13XmKlDAdFw&sai=AMfl-YQd8l5GG8PYPPZ9Ois_vE-Pr7BNEzA7VjvCbrc5mjxUNINfgxylfpN97SL-GFDBggEzwmlGY5tdRoOYZobBGZxrgDiZQfc_EWpqfQWxQw&sig=Cg0ArKJSzBHBX9bBdgQrEAE&urlfix=1&adurl=
Frame ID: 2E2F6ACF5A72AA85C735151FEE7D1B9A
Requests: 21 HTTP requests in this frame

Frame: https://fonts.googleapis.com/css?family=Roboto&display=swap
Frame ID: 6F6C1D0F2295EE1C19D1CF1A456B119B
Requests: 4 HTTP requests in this frame

Frame: https://fonts.googleapis.com/css?family=Roboto&display=swap
Frame ID: FF276740E514F85C8501F0D73404B9BD
Requests: 10 HTTP requests in this frame

Frame: https://tpc.googlesyndication.com/sodar/sodar2/209/runner.html
Frame ID: 864828933ABFEBAA9AC0854C0820B479
Requests: 1 HTTP requests in this frame

Frame: https://ads.pubmatic.com/AdServer/js/showad.js
Frame ID: F0416A5595F33CA0DB0D5A71FB35807D
Requests: 1 HTTP requests in this frame

Frame: https://acdn.adnxs.com/ib/static/usersync/v3/async_usersync.html
Frame ID: DA1DED29255713F524944D52290825BC
Requests: 1 HTTP requests in this frame

Screenshot


Page URL History Show full URLs

  1. http://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell HTTP 301
    https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell Page URL

Detected technologies

Overall confidence: 100%
Detected patterns
  • meta generator /^Drupal(?:\s([\d.]+))?/i
  • headers expires /19 Nov 1978/i

Overall confidence: 100%
Detected patterns
  • meta generator /^Drupal(?:\s([\d.]+))?/i
  • headers expires /19 Nov 1978/i

Overall confidence: 100%
Detected patterns
  • headers server /Ubuntu/i

Overall confidence: 100%
Detected patterns
  • headers server /nginx(?:\/([\d.]+))?/i

Overall confidence: 100%
Detected patterns
  • headers via /varnish(?: \(Varnish\/([\d.]+)\))?/i

Overall confidence: 100%
Detected patterns
  • script /googletagservices\.com\/tag\/js\/gpt(?:_mobile)?\.js/i

Overall confidence: 100%
Detected patterns
  • script /google-analytics\.com\/(?:ga|urchin|analytics)\.js/i

Overall confidence: 100%
Detected patterns
  • html /<link[^>]* href=[^>]+fonts\.(?:googleapis|google)\.com/i

Page Statistics

96
Requests

100 %
HTTPS

27 %
IPv6

21
Domains

33
Subdomains

24
IPs

6
Countries

1294 kB
Transfer

2724 kB
Size

0
Cookies

Page URL History

This captures the URL locations of the websites, including HTTP redirects and client-side redirects via JavaScript or Meta fields.

  1. http://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell HTTP 301
    https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell Page URL

Redirected requests

There were HTTP redirect chains for the following requests:

Request Chain 46
  • https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx HTTP 302
  • https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx&dcc=t
Request Chain 67
  • https://adrta.com/i?clid=pms&paid=pms&publisherId=23475&caid=&plid=&siteId=91975&kv1=400x300&kv2=exceljet.net&kv3=5e667b49b8f3f&kv4=83.97.23.3&kv5=chrome&kv11=17026449045e667b49b9676&kv12=91975&kv15=DE&kv16=&kv17=&kv18=&kv19=&kv24=desktop&kv26=macosx&kv27=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36 HTTP 302
  • https://ipds.adrta.com/i?__x=NHCQNCIKDI@ECIFILHFHLHPMNKILKLOM@HMNILLLLHOIKI@HMHHOMIGMEMKGMNLAFJPJLNLKIMFMJ@HKJILIHPJLJLHMHINFGCGKMHONILKNGJHCG@GCF&clid=pms&paid=pms&publisherId=23475&caid=&plid=&siteId=91975&kv1=400x300&kv2=exceljet.net&kv3=5e667b49b8f3f&kv4=83.97.23.3&kv5=chrome&kv11=17026449045e667b49b9676&kv12=91975&kv15=DE&kv16=&kv17=&kv18=&kv19=&kv24=desktop&kv26=macosx&kv27=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36
Request Chain 90
  • https://match.adsrvr.org/track/cmf/generic?ttd_pid=adaptv&ttd_tpi=1 HTTP 302
  • https://match.adsrvr.org/track/cmb/generic?ttd_pid=adaptv&ttd_tpi=1 HTTP 302
  • https://pixel.advertising.com/ups/55953/sync?uid=2153cf4a-3440-4faf-b8d8-b296c9311e79&_origin=1&gdpr=1&gdpr_consent=&piggybackCookie=2153cf4a-3440-4faf-b8d8-b296c9311e79 HTTP 302
  • https://ups.analytics.yahoo.com/ups/55953/sync?uid=2153cf4a-3440-4faf-b8d8-b296c9311e79&_origin=1&gdpr=1&gdpr_consent=&piggybackCookie=2153cf4a-3440-4faf-b8d8-b296c9311e79&apid=UP87a8b363-622a-11ea-b292-020e693014ec
Request Chain 91
  • https://sync-tm.everesttech.net/upi/pid/m7y5t93k?redir=https%3A%2F%2Fsync.adap.tv%2Fsync%3Ftype%3Dgif%26key%3Dtubemogul%26uid%3D%24%7BUSER_ID%7D HTTP 302
  • https://sync-tm.everesttech.net/ct/upi/pid/m7y5t93k?redir=https%3A%2F%2Fsync.adap.tv%2Fsync%3Ftype%3Dgif%26key%3Dtubemogul%26uid%3D%24%7BUSER_ID%7D&_test=XmZ7SwAAAE8A4lk2 HTTP 302
  • https://sync.adap.tv/sync?type=gif&key=tubemogul&uid=XmZ7SwAAAE8A4lk2&_test=XmZ7SwAAAE8A4lk2 HTTP 302
  • https://sync.adaptv.advertising.com/sync?type=gif&key=tubemogul&uid=XmZ7SwAAAE8A4lk2&_test=XmZ7SwAAAE8A4lk2
Request Chain 93
  • https://cm.g.doubleclick.net/pixel?google_nid=adaptv_dbm&google_cm&google_sc HTTP 302
  • https://cm.g.doubleclick.net/pixel?google_nid=adaptv_dbm&google_cm=&google_sc=&google_tc= HTTP 302
  • https://pixel.advertising.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1 HTTP 302
  • https://pixel.advertising.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&verify=true HTTP 302
  • https://ups.analytics.yahoo.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&apid=UP87a8b363-622a-11ea-b292-020e693014ec HTTP 302
  • https://ups.analytics.yahoo.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&apid=UP87a8b363-622a-11ea-b292-020e693014ec&verify=true
Request Chain 96
  • https://x.bidswitch.net/sync?ssp=iow_labs HTTP 302
  • https://x.bidswitch.net/ul_cb/sync?ssp=iow_labs HTTP 302
  • https://bsw.digitru.st/syncx?ssp=iow_labs&bsw_own_uuid=1104abde-90f4-4b60-a2ba-b828a0396545 HTTP 302
  • https://staging-aws-fr.bidswitch.net/sync?ssp=iow_labs&bsw_own_uuid=1104abde-90f4-4b60-a2ba-b828a0396545

96 HTTP transactions

Resource
Path
Size
x-fer
Type
MIME-Type
Primary Request sum-if-cell-contains-text-in-another-cell
exceljet.net/formula/
Redirect Chain
  • http://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
  • https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
55 KB
12 KB
Document
General
Full URL
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
99bd5fdbaf99e0ba6351497460030a7d18a9ef8451c799680bcf9c7f5cbda8dd
Security Headers
Name Value
X-Frame-Options SAMEORIGIN

Request headers

Host
exceljet.net
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_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
Sec-Fetch-Site
none
Sec-Fetch-Mode
navigate
Sec-Fetch-User
?1
Accept-Encoding
gzip, deflate, br
Accept-Language
en-US
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Server
nginx/1.10.3 (Ubuntu)
Date
Mon, 09 Mar 2020 17:22:15 GMT
Content-Type
text/html; charset=utf-8
Content-Length
11688
Connection
keep-alive
X-Drupal-Cache
HIT
Etag
"1583763392-1"
Content-Language
en
X-Frame-Options
SAMEORIGIN
X-Generator
Drupal 7 (https://www.drupal.org)
Link
<https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell>; rel="canonical",<https://exceljet.net/node/1803>; rel="shortlink"
Cache-Control
public, max-age=10800
Last-Modified
Mon, 09 Mar 2020 14:16:32 GMT
Expires
Sun, 19 Nov 1978 05:00:00 GMT
Vary
Cookie,Accept-Encoding
Content-Encoding
gzip
X-Varnish
102425449 99851445
Age
9862
Via
1.1 varnish-v4
Accept-Ranges
bytes

Redirect headers

Server
nginx/1.10.3 (Ubuntu)
Date
Mon, 09 Mar 2020 17:22:15 GMT
Content-Type
text/html
Content-Length
194
Connection
keep-alive
Location
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
css_kShW4RPmRstZ3SpIC-ZvVGNFVAi0WEMuCnI0ZkYIaFw.css
exceljet.net/sites/default/files/css/
6 KB
2 KB
Stylesheet
General
Full URL
https://exceljet.net/sites/default/files/css/css_kShW4RPmRstZ3SpIC-ZvVGNFVAi0WEMuCnI0ZkYIaFw.css
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
912856e113e646cb59dd2a480be66f5463455408b458432e0a7234664608685c
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
1907
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"773-59fe08491620c"
Vary
Accept-Encoding
X-Varnish
103253242 262147
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/css
Expires
Tue, 17 Mar 2020 16:25:03 GMT
css_VXOYHB5dlIDRUDYrm4asP-hfh1R4P_a_TWXzgkPnzgc.css
exceljet.net/sites/default/files/css/
8 KB
3 KB
Stylesheet
General
Full URL
https://exceljet.net/sites/default/files/css/css_VXOYHB5dlIDRUDYrm4asP-hfh1R4P_a_TWXzgkPnzgc.css
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
5573981c1e5d9480d150362b9b86ac3fe85f8754783ff6bf4d65f38243e7ce07
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
2235
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"8bb-59fe08491a327"
Vary
Accept-Encoding
X-Varnish
57276095 98319
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/css
Expires
Tue, 17 Mar 2020 16:25:03 GMT
css_45WydVs8hCjVuhEzRLSHFYU6gxyIQkt_fi7BQqt2EGk.css
exceljet.net/sites/default/files/css/
1 KB
1003 B
Stylesheet
General
Full URL
https://exceljet.net/sites/default/files/css/css_45WydVs8hCjVuhEzRLSHFYU6gxyIQkt_fi7BQqt2EGk.css
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
e395b2755b3c8428d5ba113344b48715853a831c88424b7f7e2ec142ab761069
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
537
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"219-59fe08491bd32"
Vary
Accept-Encoding
X-Varnish
102749447 262152
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/css
Expires
Tue, 17 Mar 2020 16:25:03 GMT
css
fonts.googleapis.com/
5 KB
838 B
Stylesheet
General
Full URL
https://fonts.googleapis.com/css?family=Droid+Sans:400,700|PT+Serif:400,400i,700
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:819::200a Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
ESF /
Resource Hash
ad689e708d79b668d9056b458ad9597f0745c63e28b153f1edd6a120daceb218
Security Headers
Name Value
Strict-Transport-Security max-age=31536000
X-Content-Type-Options nosniff
X-Frame-Options SAMEORIGIN
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

strict-transport-security
max-age=31536000
content-encoding
gzip
x-content-type-options
nosniff
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
x-xss-protection
0
last-modified
Mon, 09 Mar 2020 17:22:16 GMT
server
ESF
date
Mon, 09 Mar 2020 17:22:16 GMT
x-frame-options
SAMEORIGIN
content-type
text/css; charset=utf-8
access-control-allow-origin
*
cache-control
private, max-age=86400, stale-while-revalidate=604800
timing-allow-origin
*
link
<https://fonts.gstatic.com>; rel=preconnect; crossorigin
expires
Mon, 09 Mar 2020 17:22:16 GMT
css_iVMvyjqMPMGb8jdMFM7JDPkFo88uEHI6LPOGi0nG9Uw.css
exceljet.net/sites/default/files/css/
48 KB
10 KB
Stylesheet
General
Full URL
https://exceljet.net/sites/default/files/css/css_iVMvyjqMPMGb8jdMFM7JDPkFo88uEHI6LPOGi0nG9Uw.css
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
89532fca3a8c3cc19bf2374c14cec90cf905a3cf2e10723a2cf3868b49c6f54c
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
9836
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"266c-59fe08491f147"
Vary
Accept-Encoding
X-Varnish
82860796 294915
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/css
Expires
Tue, 17 Mar 2020 16:25:03 GMT
css_MWYXTx5-zqfwPR16uvBF8WdjnWXKknLmjCZmridY5eA.css
exceljet.net/sites/default/files/css/
15 KB
2 KB
Stylesheet
General
Full URL
https://exceljet.net/sites/default/files/css/css_MWYXTx5-zqfwPR16uvBF8WdjnWXKknLmjCZmridY5eA.css
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
3166174f1e7ecea7f03d1d7abaf045f167639d65ca9272e68c2666ae2758e5e0
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
1838
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"72e-59fe08492737d"
Vary
Accept-Encoding
X-Varnish
85759232 131084
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/css
Expires
Tue, 17 Mar 2020 16:25:03 GMT
js_2FjxiBDhUtqzDWOz-ZzyOE3jwY__GGlRiSI7FG-JPFg.js
exceljet.net/sites/default/files/js/
106 KB
36 KB
Script
General
Full URL
https://exceljet.net/sites/default/files/js/js_2FjxiBDhUtqzDWOz-ZzyOE3jwY__GGlRiSI7FG-JPFg.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
d858f18810e152dab30d63b3f99cf2384de3c18fff18695189223b146f893c58
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
36604
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"8efc-59fe08492cea2"
Vary
Accept-Encoding
X-Varnish
103200400 131081
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/javascript
Expires
Tue, 17 Mar 2020 16:25:03 GMT
js_ptR1ZjZnexk8gj2Q9mIgM2M_6ztR4ckK-i_6gzFmlNM.js
exceljet.net/sites/default/files/js/
2 KB
1 KB
Script
General
Full URL
https://exceljet.net/sites/default/files/js/js_ptR1ZjZnexk8gj2Q9mIgM2M_6ztR4ckK-i_6gzFmlNM.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
a6d4756636677b193c823d90f6622033633feb3b51e1c90afa2ffa83316694d3
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
611
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"263-59fe08492dba8"
Vary
Accept-Encoding
X-Varnish
102777555 262155
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/javascript
Expires
Tue, 17 Mar 2020 16:25:03 GMT
js_V-AtEvV_nRZpbuD5ySMuV1yNy2lDyQo8UC3IJ82P2U8.js
exceljet.net/sites/default/files/js/
21 KB
6 KB
Script
General
Full URL
https://exceljet.net/sites/default/files/js/js_V-AtEvV_nRZpbuD5ySMuV1yNy2lDyQo8UC3IJ82P2U8.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
57e02d12f57f9d16696ee0f9c9232e575c8dcb6943c90a3c502dc827cd8fd94f
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521832
Connection
keep-alive
Content-Length
5788
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"169c-59fe0849302b8"
Vary
Accept-Encoding
X-Varnish
57276099 98324
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/javascript
Expires
Tue, 17 Mar 2020 16:25:03 GMT
js_1FHb9fgZPtk59IaeibYZ0wJybxRosuraVdxzr_P0kGU.js
exceljet.net/sites/default/files/js/
2 KB
1 KB
Script
General
Full URL
https://exceljet.net/sites/default/files/js/js_1FHb9fgZPtk59IaeibYZ0wJybxRosuraVdxzr_P0kGU.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
d451dbf5f8193ed939f4869e89b619d302726f1468b2eada55dc73aff3f49065
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521833
Connection
keep-alive
Content-Length
709
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"2c5-59fe084931cc2"
Vary
Accept-Encoding
X-Varnish
102777578 294920
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/javascript
Expires
Tue, 17 Mar 2020 16:25:03 GMT
js_uwrfBOJCFVq42muTMjrq2bD-RUh8NNq_fZRTb6dsNb4.js
exceljet.net/sites/default/files/js/
8 KB
3 KB
Script
General
Full URL
https://exceljet.net/sites/default/files/js/js_uwrfBOJCFVq42muTMjrq2bD-RUh8NNq_fZRTb6dsNb4.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
bb0adf04e242155ab8da6b93323aead9b0fe45487c34dabf7d94536fa76c35be
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
521833
Connection
keep-alive
Content-Length
2217
Last-Modified
Mon, 02 Mar 2020 15:05:29 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"8a9-59fe0849350d8"
Vary
Accept-Encoding
X-Varnish
102749480 262158
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes
Content-Type
text/javascript
Expires
Tue, 17 Mar 2020 16:25:03 GMT
prebid.js
exceljet.net/
183 KB
59 KB
Script
General
Full URL
https://exceljet.net/prebid.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
adb1572725320d91a3293d898fc40e41b5951de36c38e28b50756a1f50eb0c06
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
Age
0
Transfer-Encoding
chunked
Connection
keep-alive
Last-Modified
Mon, 02 Mar 2020 17:08:12 GMT
Server
nginx/1.10.3 (Ubuntu)
ETag
"2dd77-59fe23b70bb66-gzip"
Vary
Accept-Encoding
X-Varnish
85759256
Via
1.1 varnish-v4
Cache-Control
max-age=1209600
Accept-Ranges
bytes, bytes
Content-Type
application/javascript
Expires
Mon, 23 Mar 2020 17:22:16 GMT
EXCELJET_logo_200.png
exceljet.net/sites/default/files/
4 KB
5 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/EXCELJET_logo_200.png
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
4dec34f15f11fb4fc32f79b6523ff698e29f1e2a920db975387439ea9c0f2fa6
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 29 Dec 2012 04:07:45 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
521833
ETag
"1068-4d1f5ec178640"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
102777590 327683
Connection
keep-alive
Accept-Ranges
bytes
Content-Length
4200
Expires
Tue, 17 Mar 2020 16:25:04 GMT
sum%20if%20cells%20contain%20text%20in%20another%20cell.png
exceljet.net/sites/default/files/styles/function_screen/public/images/formulas/
42 KB
42 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/function_screen/public/images/formulas/sum%20if%20cells%20contain%20text%20in%20another%20cell.png?itok=ir_aNlfT
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
cc35096cc15a7da250a25ef8a716492998336b2a782559f0c51b8150c0560768
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:07:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"a662-58bde5cb27525"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
101933419
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
42594
Expires
Mon, 23 Mar 2020 17:22:16 GMT
sum%20if%20cells%20contain%20specific%20text.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
22 KB
23 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sum%20if%20cells%20contain%20specific%20text.png?itok=iYNdsRsm
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
adb1f13a956435c141cc1f14708e47d6fd5d820c207b726185127a82460138d7
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:05:05 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"5869-58bde54d35eab"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
98424167
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
22633
Expires
Mon, 23 Mar 2020 17:22:16 GMT
sum%20if%20cells%20begin%20with.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
21 KB
21 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sum%20if%20cells%20begin%20with.png?itok=uAH1oj3t
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
1f3c3d147b2fa11fa2d0e1593e15c52d2b13d76d69383cabf108a33169866146
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:06:22 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"539a-58bde5961e947"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
101933411
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
21402
Expires
Mon, 23 Mar 2020 17:22:16 GMT
sum%20if%20cells%20are%20not%20blank.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
22 KB
22 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sum%20if%20cells%20are%20not%20blank.png?itok=4OXOp_0f
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
064872df0a883f87da4059702facdd9bb92ec344f54a5cd23c3d0d01fe631893
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:05:05 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"569a-58bde54ced7cf"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
85759303
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
22170
Expires
Mon, 23 Mar 2020 17:22:16 GMT
sum%20if%20cells%20are%20equal%20to.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
25 KB
25 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sum%20if%20cells%20are%20equal%20to.png?itok=Xxr0zBDm
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
641a429af68a7a10b8527a4fd2d5fdcc30715b300224f3ebc50d2b7df7926fea
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:05:05 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"63aa-58bde54d107b5"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
85759308
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
25514
Expires
Mon, 23 Mar 2020 17:22:16 GMT
sum%20if%20cells%20are%20not%20equal%20to.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
25 KB
25 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sum%20if%20cells%20are%20not%20equal%20to.png?itok=ptvzC9oU
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
3123803590a098de112d9c726301c2a6a9b8fcdbaa771ebf6fc494cedb6087bf
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:05:05 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"62ff-58bde54cebdc4"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
85759348
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
25343
Expires
Mon, 23 Mar 2020 17:22:16 GMT
sum%20if%20cells%20are%20equal%20to%20either.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
27 KB
27 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sum%20if%20cells%20are%20equal%20to%20either.png?itok=T2BLEnrU
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
9e2495c161431efc3c941e8bf3ed90b308c32fe1951ee614306ada5a230bc797
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:37 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"6a03-58bde53285318"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
85759353
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
27139
Expires
Mon, 23 Mar 2020 17:22:17 GMT
sumif%20one%20criteria%20multiple%20columns.png
exceljet.net/sites/default/files/styles/medium/public/images/formulas/
18 KB
19 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/formulas/sumif%20one%20criteria%20multiple%20columns.png?itok=h0Wj4KA0
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
260171d80a7a81fd41f597f03a4b67ae702cbb95f6f5c2e0af625df0d9853ede
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:07:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"49c3-58bde5cb51a3c"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
82860820
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
18883
Expires
Mon, 23 Mar 2020 17:22:17 GMT
exceljet_sumif_0.png
exceljet.net/sites/default/files/styles/medium/public/images/functions/main/
14 KB
14 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/functions/main/exceljet_sumif_0.png?itok=OVGREl_L
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
24f53dcd8de26fb9ab9f8d1aa300da21f3395be6c9afc19f6da852498877d955
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:05:08 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"3770-58bde5503ca93"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103060401
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
14192
Expires
Mon, 23 Mar 2020 17:22:17 GMT
exceljet_sumifs_0.png
exceljet.net/sites/default/files/styles/medium/public/images/functions/main/
16 KB
16 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/functions/main/exceljet_sumifs_0.png?itok=c482-YhO
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
c36349b9ad5c541d7b374602e747ba952da9fc4b33d6f6df4df395c795dc834a
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:38 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"4012-58bde532d0e0a"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103162800
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
16402
Expires
Mon, 23 Mar 2020 17:22:17 GMT
How%20to%20use%20the%20SUMIF%20function-thumb.png
exceljet.net/sites/default/files/styles/medium/public/images/lesson/
14 KB
14 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/medium/public/images/lesson/How%20to%20use%20the%20SUMIF%20function-thumb.png?itok=Ifn9XBXi
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
8f56b300fb05dc7a5a1fda67ec43a1302773da6fb5fd62b78b4ada7fb3eecb44
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:05:06 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"3787-58bde54d96c28"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103253264
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
14215
Expires
Mon, 23 Mar 2020 17:22:17 GMT
cover_core_formula.png
exceljet.net/sites/default/files/images/argo/
46 KB
47 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/images/argo/cover_core_formula.png
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
2b0ff00e38503e45bea7e8a0ef4c5ceff0b45d562182a47b7a80a936150ec228
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Fri, 06 May 2016 23:28:10 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
521833
ETag
"b8d5-53234cfd3b680"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
102610786 229402
Connection
keep-alive
Accept-Ranges
bytes
Content-Length
47317
Expires
Tue, 17 Mar 2020 16:25:04 GMT
IMG_0775_c%20125.jpg
exceljet.net/sites/default/files/images/argo/
24 KB
24 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/images/argo/IMG_0775_c%20125.jpg
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
62bbfded3a2fcb9a24f8b9eb62b5e23a70c52513edaba6529e2cb8cc2257bd6b
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sun, 30 Apr 2017 01:32:55 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
521834
ETag
"5fc1-54e584930b0eb"
Content-Type
image/jpeg
Cache-Control
max-age=1209600
X-Varnish
85759344 32780
Connection
keep-alive
Accept-Ranges
bytes
Content-Length
24513
Expires
Tue, 17 Mar 2020 16:25:03 GMT
cover_core_excel.png
exceljet.net/sites/default/files/styles/thumbnail/public/images/course/
11 KB
11 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/thumbnail/public/images/course/cover_core_excel.png?itok=3wNUqFvE
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
a376fd6a6def28335937568b481ee1cdb83d6291c10fc3c31d91c06719a7bd84
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"2a85-58bde51ecab51"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103060419
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
10885
Expires
Mon, 23 Mar 2020 17:22:17 GMT
cover_core_pivot.png
exceljet.net/sites/default/files/styles/thumbnail/public/images/course/
10 KB
10 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/thumbnail/public/images/course/cover_core_pivot.png?itok=_7rRPV43
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
66d5e6dbe8e34aca82d039e6ffe9a3a753246921c37ddc49c6f054b41ca42037
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"276a-58bde51ecdf66"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
101446549
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
10090
Expires
Mon, 23 Mar 2020 17:22:17 GMT
cover_core_formula_0.png
exceljet.net/sites/default/files/styles/thumbnail/public/images/course/
10 KB
11 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/thumbnail/public/images/course/cover_core_formula_0.png?itok=xh6D089q
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
b599918c6e69885715973620b0279bc23dbee5b1be558345ca5c55c25623bf3e
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"295e-58bde51efb892"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103162827
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
10590
Expires
Mon, 23 Mar 2020 17:22:17 GMT
excel_shortcuts.png
exceljet.net/sites/default/files/styles/thumbnail/public/images/course/
10 KB
11 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/thumbnail/public/images/course/excel_shortcuts.png?itok=NFwXUFtr
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
76cc10f394bbfba4764735523d77180052bf5a9ca9a0b1a83a5b8a99f498bf3b
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"2881-58bde51f19a58"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103006320
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
10369
Expires
Mon, 23 Mar 2020 17:22:17 GMT
cover_core_charts.png
exceljet.net/sites/default/files/styles/thumbnail/public/images/course/
9 KB
10 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/thumbnail/public/images/course/cover_core_charts.png?itok=lcqbKY9M
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
110233d13f03c7bc071c69fbbf5d97739f0c3f97bdf78b260b51c5a324c3c5af
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:17 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"2538-58bde51fb9f77"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
101446552
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
9528
Expires
Mon, 23 Mar 2020 17:22:17 GMT
cover_excel_tables.png
exceljet.net/sites/default/files/styles/thumbnail/public/images/course/
9 KB
9 KB
Image
General
Full URL
https://exceljet.net/sites/default/files/styles/thumbnail/public/images/course/cover_excel_tables.png?itok=OQsh0trm
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
1232908a9ba85dce548fdd54ee669e64bbfd1c112f3e422b063ea49c2360e90a
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Sat, 22 Jun 2019 00:04:18 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
0
ETag
"22aa-58bde51fbd38c"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
103060442
Connection
keep-alive
Accept-Ranges
bytes, bytes
Content-Length
8874
Expires
Mon, 23 Mar 2020 17:22:17 GMT
analytics.js
www.google-analytics.com/
44 KB
18 KB
Script
General
Full URL
https://www.google-analytics.com/analytics.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:821::200e Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
Golfe2 /
Resource Hash
eaf1b128b927ac2868755cb7366d35554255c8af362235afe270f9614f8c806d
Security Headers
Name Value
Strict-Transport-Security max-age=10886400; includeSubDomains; preload
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

strict-transport-security
max-age=10886400; includeSubDomains; preload
content-encoding
gzip
x-content-type-options
nosniff
last-modified
Thu, 06 Feb 2020 00:21:02 GMT
server
Golfe2
age
5406
date
Mon, 09 Mar 2020 15:52:10 GMT
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
public, max-age=7200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
18174
expires
Mon, 09 Mar 2020 17:52:10 GMT
apstag.js
c.amazon-adsystem.com/aax2/
87 KB
25 KB
Script
General
Full URL
https://c.amazon-adsystem.com/aax2/apstag.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.222.153.241 Seattle, United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-52-222-153-241.fra53.r.cloudfront.net
Software
Server /
Resource Hash
ac2a58f9d55c4642121cfb6f7e213cbc882bbdd75ef171ca8a07ed982ef693ce

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Sun, 08 Mar 2020 22:00:54 GMT
content-encoding
gzip
server
Server
age
69681
etag
1dcfbf3986ee8b9c3abbc67eb808ab43
x-cache
Hit from cloudfront
content-type
application/javascript
status
200
cache-control
public, max-age=86400
x-amz-cf-pop
FRA53
accept-ranges
bytes
x-amz-cf-id
ff9p0McUxuEjT33HBlw1xyLCMd0iUrTYq1ySvCMn5gDaXkzRAVqDMg==
via
1.1 4d1cbe225c5d30aa78ec9a6fa1ba4211.cloudfront.net (CloudFront)
throbber-inactive.png
exceljet.net/misc/
320 B
739 B
Image
General
Full URL
https://exceljet.net/misc/throbber-inactive.png
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
3dfc7f57df739ac6410ddf0791b80fe55de158c52c294b46046f4366f35e043e
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/sites/default/files/css/css_kShW4RPmRstZ3SpIC-ZvVGNFVAi0WEMuCnI0ZkYIaFw.css
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:16 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Wed, 18 Dec 2019 09:07:46 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
521833
ETag
"140-599f6c72a5c80"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
85759335 229393
Connection
keep-alive
Accept-Ranges
bytes
Content-Length
320
Expires
Tue, 17 Mar 2020 16:25:04 GMT
EJRVQgYoZZY2vCFuvAFWzr-_dSb_.woff2
fonts.gstatic.com/s/ptserif/v11/
13 KB
13 KB
Font
General
Full URL
https://fonts.gstatic.com/s/ptserif/v11/EJRVQgYoZZY2vCFuvAFWzr-_dSb_.woff2
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81d::2003 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
6d6cd55572e8be7aa03c122e0ef98bf72d91a2caa2dddfe3c7c5b50f67d2bd07
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://fonts.googleapis.com/css?family=Droid+Sans:400,700|PT+Serif:400,400i,700
Origin
https://exceljet.net
Sec-Fetch-Dest
font
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Mon, 24 Feb 2020 23:11:57 GMT
x-content-type-options
nosniff
last-modified
Mon, 22 Jul 2019 19:23:27 GMT
server
sffe
age
1188619
content-type
font/woff2
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
cache-control
public, max-age=31536000
accept-ranges
bytes
timing-allow-origin
*
access-control-allow-origin
*
content-length
13280
x-xss-protection
0
expires
Tue, 23 Feb 2021 23:11:57 GMT
social-icons.png
exceljet.net/sites/all/themes/exceljet/images/
6 KB
6 KB
Image
General
Full URL
https://exceljet.net/sites/all/themes/exceljet/images/social-icons.png
Requested by
Host: exceljet.net
URL: https://exceljet.net/sites/default/files/js/js_2FjxiBDhUtqzDWOz-ZzyOE3jwY__GGlRiSI7FG-JPFg.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2600:3c00::f03c:91ff:fee7:ea6e , United States, ASN63949 (LINODE-AP Linode, LLC, US),
Reverse DNS
Software
nginx/1.10.3 (Ubuntu) /
Resource Hash
e55af38d89fc4cb497fc8ce7dfd41c14316d6c95ea48a49181aec65d7566f605
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/sites/default/files/css/css_iVMvyjqMPMGb8jdMFM7JDPkFo88uEHI6LPOGi0nG9Uw.css
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Via
1.1 varnish-v4
X-Content-Type-Options
nosniff
Last-Modified
Thu, 26 Jun 2014 19:47:36 GMT
Server
nginx/1.10.3 (Ubuntu)
Age
521834
ETag
"16a3-4fcc276ede600"
Content-Type
image/png
Cache-Control
max-age=1209600
X-Varnish
57276116 163855
Connection
keep-alive
Accept-Ranges
bytes
Content-Length
5795
Expires
Tue, 17 Mar 2020 16:25:03 GMT
EJRTQgYoZZY2vCFuvAFT_r21cgT9rcs.woff2
fonts.gstatic.com/s/ptserif/v11/
14 KB
14 KB
Font
General
Full URL
https://fonts.gstatic.com/s/ptserif/v11/EJRTQgYoZZY2vCFuvAFT_r21cgT9rcs.woff2
Requested by
Host: exceljet.net
URL: https://exceljet.net/sites/default/files/js/js_2FjxiBDhUtqzDWOz-ZzyOE3jwY__GGlRiSI7FG-JPFg.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81d::2003 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
d3b9ac60281114eb252c949187818336066886576d5fc78f31cc8c4c2d94531f
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://fonts.googleapis.com/css?family=Droid+Sans:400,700|PT+Serif:400,400i,700
Origin
https://exceljet.net
Sec-Fetch-Dest
font
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Tue, 04 Feb 2020 17:35:53 GMT
x-content-type-options
nosniff
last-modified
Mon, 22 Jul 2019 19:24:32 GMT
server
sffe
age
2936783
content-type
font/woff2
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
cache-control
public, max-age=31536000
accept-ranges
bytes
timing-allow-origin
*
access-control-allow-origin
*
content-length
14020
x-xss-protection
0
expires
Wed, 03 Feb 2021 17:35:53 GMT
EJRSQgYoZZY2vCFuvAnt66qSVyvVp8NA.woff2
fonts.gstatic.com/s/ptserif/v11/
13 KB
13 KB
Font
General
Full URL
https://fonts.gstatic.com/s/ptserif/v11/EJRSQgYoZZY2vCFuvAnt66qSVyvVp8NA.woff2
Requested by
Host: exceljet.net
URL: https://exceljet.net/sites/default/files/js/js_2FjxiBDhUtqzDWOz-ZzyOE3jwY__GGlRiSI7FG-JPFg.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81d::2003 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
a75a7bf10f415b7c91f0b959177f3f1779e78cbf735601e41fb982c2b1cf4be2
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://fonts.googleapis.com/css?family=Droid+Sans:400,700|PT+Serif:400,400i,700
Origin
https://exceljet.net
Sec-Fetch-Dest
font
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Wed, 05 Feb 2020 00:38:56 GMT
x-content-type-options
nosniff
last-modified
Mon, 22 Jul 2019 19:24:48 GMT
server
sffe
age
2911400
content-type
font/woff2
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
cache-control
public, max-age=31536000
accept-ranges
bytes
timing-allow-origin
*
access-control-allow-origin
*
content-length
13372
x-xss-protection
0
expires
Thu, 04 Feb 2021 00:38:56 GMT
SlGVmQWMvZQIdix7AFxXkHNSbRYXags.woff2
fonts.gstatic.com/s/droidsans/v12/
11 KB
11 KB
Font
General
Full URL
https://fonts.gstatic.com/s/droidsans/v12/SlGVmQWMvZQIdix7AFxXkHNSbRYXags.woff2
Requested by
Host: exceljet.net
URL: https://exceljet.net/sites/default/files/js/js_2FjxiBDhUtqzDWOz-ZzyOE3jwY__GGlRiSI7FG-JPFg.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81d::2003 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
c8cb742dbb60decab090cf738bfef2d8a780141573e9a2a3854bf3f78919faed
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://fonts.googleapis.com/css?family=Droid+Sans:400,700|PT+Serif:400,400i,700
Origin
https://exceljet.net
Sec-Fetch-Dest
font
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Tue, 25 Feb 2020 02:07:22 GMT
x-content-type-options
nosniff
last-modified
Thu, 20 Feb 2020 02:00:07 GMT
server
sffe
age
1178094
content-type
font/woff2
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
cache-control
public, max-age=31536000
accept-ranges
bytes
timing-allow-origin
*
access-control-allow-origin
*
content-length
11236
x-xss-protection
0
expires
Wed, 24 Feb 2021 02:07:22 GMT
collect
www.google-analytics.com/r/
35 B
109 B
Image
General
Full URL
https://www.google-analytics.com/r/collect?v=1&_v=j81&a=1006225109&t=pageview&_s=1&dl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&ul=en-us&de=UTF-8&dt=Excel%20formula%3A%20Sum%20if%20cell%20contains%20text%20in%20another%20cell%20%7C%20Exceljet&sd=24-bit&sr=1600x1200&vp=1585x1200&je=0&_u=IEBAAEAB~&jid=705677607&gjid=1225003697&cid=1576610845.1583774537&tid=UA-19676266-7&_gid=214250351.1583774537&_r=1&z=781696953
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:821::200e Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
Golfe2 /
Resource Hash
8337212354871836e6763a41e615916c89bac5b3f1f0adf60ba43c7c806e1015
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

pragma
no-cache
date
Mon, 09 Mar 2020 17:22:16 GMT
x-content-type-options
nosniff
last-modified
Sun, 17 May 1998 03:00:00 GMT
server
Golfe2
access-control-allow-origin
*
content-type
image/gif
status
200
cache-control
no-cache, no-store, must-revalidate
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
35
expires
Fri, 01 Jan 1990 00:00:00 GMT
bid
c.amazon-adsystem.com/e/dtb/
121 B
500 B
XHR
General
Full URL
https://c.amazon-adsystem.com/e/dtb/bid?src=600&u=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&pid=WaCzfaV22Xscq&cb=0&ws=1600x1200&v=7.47.00&t=2000&slots=%5B%7B%22sd%22%3A%220%22%2C%22s%22%3A%5B%22970x90%22%2C%22728x90%22%5D%2C%22sn%22%3A%2291182459%2FEJ_Leaderboard_Pos1%22%7D%2C%7B%22sd%22%3A%221%22%2C%22s%22%3A%5B%22300x250%22%2C%22300x600%22%5D%2C%22sn%22%3A%2291182459%2FEJ_RR_Pos1%22%7D%2C%7B%22sd%22%3A%222%22%2C%22s%22%3A%5B%22300x250%22%2C%22300x600%22%2C%22336x280%22%2C%22350x260%22%2C%22380x251%22%5D%2C%22sn%22%3A%2291182459%2FEJ_RR_Pos2%22%7D%5D&cfgv=0&pubid=8e1e3253-bcda-4e7f-92d0-b73da4e1c4c4&gdprl=%7B%22status%22%3A%22no-cmp%22%7D
Requested by
Host: c.amazon-adsystem.com
URL: https://c.amazon-adsystem.com/aax2/apstag.js
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.222.153.241 Seattle, United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-52-222-153-241.fra53.r.cloudfront.net
Software
Server /
Resource Hash
65b9332bcc97c85599a5b847df94c4e09e5622aa9880e0664ffa048cd52145ff

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
server
Server
x-amz-cf-pop
FRA53
status
200
vary
Accept-Encoding,User-Agent
x-cache
Miss from cloudfront
content-type
text/javascript;charset=UTF-8
access-control-allow-origin
https://exceljet.net
access-control-allow-credentials
true
timing-allow-origin
*
content-length
128
via
1.1 4d1cbe225c5d30aa78ec9a6fa1ba4211.cloudfront.net (CloudFront)
x-amz-cf-id
dqOUkCBcL-Y-wLnjQGm83iurgAzHX6GqTBqgy0YxoCalWMDHw1FsgQ==
aps_csm.js
c.amazon-adsystem.com/bao-csm/aps-comm/
6 KB
3 KB
XHR
General
Full URL
https://c.amazon-adsystem.com/bao-csm/aps-comm/aps_csm.js
Requested by
Host: c.amazon-adsystem.com
URL: https://c.amazon-adsystem.com/aax2/apstag.js
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.222.153.241 Seattle, United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-52-222-153-241.fra53.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
06b99248a163333e36980a6cfb756f1a7de60fa49517162b87b1a44d5d48f844

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Mon, 09 Mar 2020 08:42:31 GMT
content-encoding
gzip
vary
Origin
age
31186
x-cache
Hit from cloudfront
status
200
access-control-allow-origin
*
last-modified
Thu, 05 Mar 2020 08:28:46 GMT
server
AmazonS3
access-control-max-age
3000
access-control-allow-methods
GET
content-type
application/javascript
via
1.1 ec6662ba477736a13086dd664a1145be.cloudfront.net (CloudFront)
cache-control
public, max-age=86400
x-amz-cf-pop
FRA53
x-amz-cf-id
_Tuo_N6_cRws4F8zTarnLlXqiowCMgugI7LMz2EvcI9gVM6v1Yqb8Q==
prebid
ib.adnxs.com/ut/v3/
376 B
1 KB
XHR
General
Full URL
https://ib.adnxs.com/ut/v3/prebid
Requested by
Host: exceljet.net
URL: https://exceljet.net/prebid.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_ECDSA, AES_128_GCM
Server
37.252.173.38 , Ascension Island, ASN29990 (ASN-APPNEX, US),
Reverse DNS
537.bm-nginx-loadbalancer.mgmt.fra1.adnexus.net
Software
nginx/1.13.4 /
Resource Hash
e233e023875f13d3815c8234bfb61b18ca25e8731222cb009896c70e8457d102
Security Headers
Name Value
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Content-Type
text/plain

Response headers

Pragma
no-cache
Date
Mon, 09 Mar 2020 17:22:18 GMT
X-Proxy-Origin
83.97.23.3; 83.97.23.3; 537.bm-nginx-loadbalancer.mgmt.fra1; *.adnxs.com; 37.252.173.13:80
AN-X-Request-Uuid
a6033403-3d6c-4571-a905-e6da752fd8a7
Server
nginx/1.13.4
P3P
policyref="http://cdn.adnxs.com/w3c/policy/p3p.xml", CP="NOI DSP COR ADM PSAo PSDo OURo SAMo UNRo OTRo BUS COM NAV DEM STA PRE"
Access-Control-Allow-Origin
https://exceljet.net
Cache-Control
no-store, no-cache, private
Access-Control-Allow-Credentials
true
Connection
keep-alive
Content-Type
application/json; charset=utf-8
Content-Length
376
X-XSS-Protection
0
Expires
Sat, 15 Nov 2008 16:00:00 GMT
hb
grid.bidswitch.net/
2 B
371 B
XHR
General
Full URL
https://grid.bidswitch.net/hb?auids=4123%2C3174%2C4300&sizes=970x90%2C728x90%2C300x250%2C300x600%2C336x280%2C350x260%2C380x251&r=5220f2d9b6d20e&wrapperType=Prebid_js&wrapperVersion=3.7.0-pre&u=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&wtimeout=2000
Requested by
Host: exceljet.net
URL: https://exceljet.net/prebid.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
18.197.186.176 Frankfurt am Main, Germany, ASN16509 (AMAZON-02, US),
Reverse DNS
ec2-18-197-186-176.eu-central-1.compute.amazonaws.com
Software
/
Resource Hash
44136fa355b3678a1146ad16f7e8649e94fb4fc21fe77e8310c060f61caaff8a

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Content-Type
text/plain

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
P3P
CP="NOI DSP COR NID CURa ADMa DEVa PSAa PSDa OUR BUS COM INT OTC PUR STA"
Access-Control-Allow-Origin
https://exceljet.net
Cache-Control
no-cache, no-store, must-revalidate
Access-Control-Allow-Credentials
true
Connection
keep-alive
Content-Type
application/json; charset=UTF-8
Content-Length
2
translator
hbopenbid.pubmatic.com/
0
114 B
XHR
General
Full URL
https://hbopenbid.pubmatic.com/translator?source=prebid-client
Requested by
Host: exceljet.net
URL: https://exceljet.net/prebid.js
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
185.64.189.112 , United Kingdom, ASN62713 (AS-PUBMATIC, US),
Reverse DNS
Software
/
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Content-Type
text/plain

Response headers

status
204
date
Mon, 09 Mar 2020 17:22:17 GMT
cache-control
no-cache, no-store, must-revalidate
access-control-allow-credentials
true
access-control-allow-origin
https://exceljet.net
Cookie set iu3
aax-eu.amazon-adsystem.com/s/ Frame AF8E
Redirect Chain
  • https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx
  • https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx&dcc=t
0
0
Document
General
Full URL
https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx&dcc=t
Requested by
Host: c.amazon-adsystem.com
URL: https://c.amazon-adsystem.com/aax2/apstag.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.94.216.48 Dublin, Ireland, ASN16509 (AMAZON-02, US),
Reverse DNS
Software
Server /
Resource Hash

Request headers

Host
aax-eu.amazon-adsystem.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_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
Sec-Fetch-Site
cross-site
Sec-Fetch-Mode
navigate
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Accept-Encoding
gzip, deflate, br
Accept-Language
en-US
Cookie
ad-id=A8cBqxQf3UpCtXiHa7HfRlc|t
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell

Response headers

Server
Server
Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Type
text/html;charset=ISO-8859-1
Content-Length
195
Connection
keep-alive
Cache-Control
max-age=0, no-cache, no-store, private, must-revalidate, s-maxage=0
Pragma
no-cache
Expires
Thu, 01 Jan 1970 00:00:00 GMT
p3p
policyref="https://www.amazon.com/w3c/p3p.xml", CP="PSAo PSDo OUR SAM OTR DSP COR"
Set-Cookie
ad-id=A8cBqxQf3UpCtXiHa7HfRlc; Domain=.amazon-adsystem.com; Expires=Thu, 01-Oct-2020 17:22:17 GMT; Path=/; Secure; HttpOnly; SameSite=None ad-privacy=0; Domain=.amazon-adsystem.com; Expires=Tue, 01-Apr-2025 17:22:17 GMT; Path=/; Secure; HttpOnly; SameSite=None
Vary
Accept-Encoding,User-Agent
Content-Encoding
gzip

Redirect headers

Server
Server
Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Length
0
Connection
keep-alive
Cache-Control
max-age=0, no-cache, no-store, private, must-revalidate, s-maxage=0
Pragma
no-cache
Expires
Thu, 01 Jan 1970 00:00:00 GMT
p3p
policyref="https://www.amazon.com/w3c/p3p.xml", CP="PSAo PSDo OUR SAM OTR DSP COR"
Location
https://aax-eu.amazon-adsystem.com/s/iu3?cm3ppd=1&d=dtb-pub&csif=t&dl=rbd_oath_r1u_dm_dmx&dcc=t
Set-Cookie
ad-id=A8cBqxQf3UpCtXiHa7HfRlc|t; Domain=.amazon-adsystem.com; Expires=Thu, 01-Oct-2020 17:22:17 GMT; Path=/; Secure; HttpOnly; SameSite=None
Vary
User-Agent
gpt.js
www.googletagservices.com/tag/js/
44 KB
14 KB
Script
General
Full URL
https://www.googletagservices.com/tag/js/gpt.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81f::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
2d1a1e169b7a4da51417cc2f5d7383985686e3f8a9393b60378218ecb421bed8
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
server
sffe
etag
"451 / 115 of 1000 / last-modified: 1583770429"
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
private, max-age=900, stale-while-revalidate=3600
timing-allow-origin
*
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
14601
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:17 GMT
integrator.js
adservice.google.de/adsid/
109 B
171 B
Script
General
Full URL
https://adservice.google.de/adsid/integrator.js?domain=exceljet.net
Requested by
Host: www.googletagservices.com
URL: https://www.googletagservices.com/tag/js/gpt.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81a::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
cafe /
Resource Hash
0482a98d09daebc18a0d2e1ed8f748da5b0179e61223ed541101df1f4699f073
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
content-type
application/javascript; charset=UTF-8
server
cafe
p3p
CP="This is not a P3P policy! See http://support.google.com/accounts/answer/151657 for more info."
status
200
cache-control
private, no-cache, no-store
content-disposition
attachment; filename="f.txt"
timing-allow-origin
*
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
104
x-xss-protection
0
integrator.js
adservice.google.com/adsid/
109 B
171 B
Script
General
Full URL
https://adservice.google.com/adsid/integrator.js?domain=exceljet.net
Requested by
Host: www.googletagservices.com
URL: https://www.googletagservices.com/tag/js/gpt.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81a::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
cafe /
Resource Hash
0482a98d09daebc18a0d2e1ed8f748da5b0179e61223ed541101df1f4699f073
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
content-type
application/javascript; charset=UTF-8
server
cafe
p3p
CP="This is not a P3P policy! See http://support.google.com/accounts/answer/151657 for more info."
status
200
cache-control
private, no-cache, no-store
content-disposition
attachment; filename="f.txt"
timing-allow-origin
*
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
104
x-xss-protection
0
pubads_impl_2020030501.js
securepubads.g.doubleclick.net/gpt/
165 KB
60 KB
Script
General
Full URL
https://securepubads.g.doubleclick.net/gpt/pubads_impl_2020030501.js
Requested by
Host: www.googletagservices.com
URL: https://www.googletagservices.com/tag/js/gpt.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
172.217.23.130 , United States, ASN15169 (GOOGLE, US),
Reverse DNS
fra16s18-in-f2.1e100.net
Software
sffe /
Resource Hash
8ee04e0441c9e51785d17ac835a93cf4d30d90826f87350b42ba233496a26f55
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
last-modified
Thu, 05 Mar 2020 14:08:10 GMT
server
sffe
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
private, immutable, max-age=31536000
accept-ranges
bytes
timing-allow-origin
*
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
61481
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:17 GMT
ads
securepubads.g.doubleclick.net/gampad/
15 KB
8 KB
XHR
General
Full URL
https://securepubads.g.doubleclick.net/gampad/ads?gdfp_req=1&pvsid=2229587217246988&correlator=4447424663167279&output=ldjh&impl=fifs&adsid=NT&eid=21065393%2C21065662&vrg=2020030501&guci=1.2.0.0.2.2.0.0&sc=1&sfv=1-0-37&ecs=20200309&iu_parts=91182459%2CEJ_Leaderboard_Pos1%2CEJ_RR_Pos1%2CEJ_RR_Pos2&enc_prev_ius=%2F0%2F1%2C%2F0%2F2%2C%2F0%2F3&prev_iu_szs=970x90%7C728x90%2C300x250%7C300x600%2C300x250%7C300x600%7C336x280%7C350x260%7C380x251&prev_scp=amznbid%3D2%26amznp%3D2%7Camznbid%3D2%26amznp%3D2%7Camznbid%3D2%26amznp%3D2&cust_params=floortest%3Dfalse%26refreshIteration%3D0&cookie_enabled=1&bc=31&abxe=1&lmt=1583763392&dt=1583774537329&dlt=1583774535985&idt=1329&frm=20&biw=1585&bih=1200&oid=3&adxs=203%2C1003%2C1003&adys=179%2C323%2C1518&adks=4031474704%2C550721306%2C856574660&ucis=1%7C2%7C3&ifi=1&u_tz=60&u_his=2&u_h=1200&u_w=1600&u_ah=1200&u_aw=1600&u_cd=24&u_sd=1&flash=0&url=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&dssz=19&icsg=8650730&std=0&vis=1&dmc=8&scr_x=0&scr_y=0&psz=1180x90%7C380x250%7C380x250&msz=1180x90%7C380x250%7C380x250&ga_vid=1576610845.1583774537&ga_sid=1583774537&ga_hid=1006225109&fws=0%2C0%2C512&ohw=0%2C0%2C0
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
172.217.23.130 , United States, ASN15169 (GOOGLE, US),
Reverse DNS
fra16s18-in-f2.1e100.net
Software
cafe /
Resource Hash
b8d0e162509a6196e3c2c0f0feb37761671d04542568b021adba8db1aaab1029
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
br
x-content-type-options
nosniff
google-mediationgroup-id
-2,-2
p3p
policyref="https://googleads.g.doubleclick.net/pagead/gcn_p3p_.xml", CP="CURa ADMa DEVa TAIo PSAo PSDo OUR IND UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
7713
x-xss-protection
0
google-lineitem-id
-1,-2,4349373535
pragma
no-cache
server
cafe
google-mediationtag-id
-2
google-creative-id
-1,-2,138222681245
content-type
text/plain; charset=UTF-8
access-control-allow-origin
https://exceljet.net
cache-control
no-cache, must-revalidate
access-control-allow-credentials
true
timing-allow-origin
*
expires
Fri, 01 Jan 1990 00:00:00 GMT
pubads_impl_rendering_2020030501.js
securepubads.g.doubleclick.net/gpt/
69 KB
25 KB
Script
General
Full URL
https://securepubads.g.doubleclick.net/gpt/pubads_impl_rendering_2020030501.js
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
172.217.23.130 , United States, ASN15169 (GOOGLE, US),
Reverse DNS
fra16s18-in-f2.1e100.net
Software
sffe /
Resource Hash
ffdc18ac8f47bcd50dd9c33532c334e7073717a62b367d95b9cb1561048547dc
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
last-modified
Thu, 05 Mar 2020 14:08:10 GMT
server
sffe
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
private, immutable, max-age=31536000
accept-ranges
bytes
timing-allow-origin
*
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
25689
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:17 GMT
container.html
tpc.googlesyndication.com/safeframe/1-0-37/html/
0
0
Other
General
Full URL
https://tpc.googlesyndication.com/safeframe/1-0-37/html/container.html
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:814::2001 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
/
Resource Hash

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
empty

Response headers

container.html
tpc.googlesyndication.com/safeframe/1-0-37/html/ Frame F60F
0
0
Document
General
Full URL
https://tpc.googlesyndication.com/safeframe/1-0-37/html/container.html
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_rendering_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:814::2001 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

:method
GET
:authority
tpc.googlesyndication.com
:scheme
https
:path
/safeframe/1-0-37/html/container.html
pragma
no-cache
cache-control
no-cache
upgrade-insecure-requests
1
user-agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
sec-fetch-dest
iframe
accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
sec-fetch-site
cross-site
sec-fetch-mode
navigate
referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
accept-encoding
gzip, deflate, br
accept-language
en-US
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell

Response headers

status
200
accept-ranges
bytes
vary
Accept-Encoding
content-encoding
gzip
content-type
text/html
timing-allow-origin
*
content-length
2973
date
Mon, 09 Mar 2020 16:25:24 GMT
expires
Tue, 09 Mar 2021 16:25:24 GMT
last-modified
Thu, 21 Nov 2019 16:01:11 GMT
x-content-type-options
nosniff
server
sffe
x-xss-protection
0
cache-control
public, immutable, max-age=31536000
age
3413
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
osd.js
www.googletagservices.com/activeview/js/current/
73 KB
27 KB
Script
General
Full URL
https://www.googletagservices.com/activeview/js/current/osd.js?cb=%2Fr20100101
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81f::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
b8b7d1f10441c7349e88ed2a168e0635836f6724999f91ea8d15ecd4811dad38
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
server
sffe
etag
"1583497562441669"
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
private, max-age=3000
accept-ranges
bytes
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
27645
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:17 GMT
view
securepubads.g.doubleclick.net/pcs/ Frame 2E2F
0
0
Fetch
General
Full URL
https://securepubads.g.doubleclick.net/pcs/view?xai=AKAOjssnB-Kx6agj4WeS8ATEB4Tp-Zh4kH-buVpjPluvmJ6DFpUfkLkvBVOM5kFmdct_HixjGOwD7C0_nybNjWvRuY_Bkt85zW8j3cWRXiWVY6uVIAvSFQvCv6KUpZOa3IqpU5jElwpoNFb3StTSTjqmaIu6JDO2oj4aDpqIc3ceaW1dgG2RDz7ASypM-lITKztXtXsTDiFcpHTZSIIgVKzZqsn-KYtmS6E-0LIugozAq0hghg8Ov60qwyYxIpXPr13XmKlDAdFw&sai=AMfl-YQd8l5GG8PYPPZ9Ois_vE-Pr7BNEzA7VjvCbrc5mjxUNINfgxylfpN97SL-GFDBggEzwmlGY5tdRoOYZobBGZxrgDiZQfc_EWpqfQWxQw&sig=Cg0ArKJSzBHBX9bBdgQrEAE&urlfix=1&adurl=
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
172.217.23.130 , United States, ASN15169 (GOOGLE, US),
Reverse DNS
fra16s18-in-f2.1e100.net
Software
cafe /
Resource Hash
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
empty

Response headers

timing-allow-origin
*
date
Mon, 09 Mar 2020 17:22:17 GMT
x-content-type-options
nosniff
server
cafe
status
200
p3p
policyref="https://googleads.g.doubleclick.net/pagead/gcn_p3p_.xml", CP="CURa ADMa DEVa TAIo PSAo PSDo OUR IND UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"
access-control-allow-origin
*
cache-control
private
content-type
image/gif
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
0
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:17 GMT
liveView.php
live.sekindo.com/live/ Frame 2E2F
23 KB
7 KB
Script
General
Full URL
https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_rendering_2020030501.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx / PHP/7.3.14
Resource Hash
40ba9d6ba2e284332ccfba657abb51667c07b4077fa3dc79ae7741d1c2dd1dc1

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Pragma
no-cache
Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Server
nginx
Age
0
X-Powered-By
PHP/7.3.14
Transfer-Encoding
chunked
P3P
CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
Access-Control-Allow-Origin
*
Cache-Control
no-store
Content-Type
text/javascript; charset=utf-8
osd_listener.js
www.googletagservices.com/activeview/js/current/ Frame 2E2F
73 KB
28 KB
Script
General
Full URL
https://www.googletagservices.com/activeview/js/current/osd_listener.js?cache=r20110914
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_rendering_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81f::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
42842c4928fd167ff3cb57a681061cc609ff70b25f836395da313a26456e1820
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:17 GMT
content-encoding
gzip
x-content-type-options
nosniff
server
sffe
etag
"1583497562441669"
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
private, max-age=3000
accept-ranges
bytes
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
28126
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:17 GMT
liveView.php
live.sekindo.com/live/ Frame 2E2F
3 KB
2 KB
Script
General
Full URL
https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx / PHP/7.3.14
Resource Hash
ccd60a06b60160dc987d719bccb83804a4e054797be513bf039c0b1353a31c17

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Pragma
no-cache
Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Server
nginx
Age
0
X-Powered-By
PHP/7.3.14
Transfer-Encoding
chunked
P3P
CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
Access-Control-Allow-Origin
*
Cache-Control
no-store
Content-Type
text/javascript; charset=utf-8
DetectGDPR2.v1.0.js
live.sekindo.com/content/ClientDetections/ Frame 2E2F
8 KB
3 KB
Script
General
Full URL
https://live.sekindo.com/content/ClientDetections/DetectGDPR2.v1.0.js
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx /
Resource Hash
ace61d80f3fe90bbb02ab328d9705b57a9c8a95d3a0bf6b4cd510d4dacd033df

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Last-Modified
Sun, 26 Jan 2020 18:48:12 GMT
Server
nginx
ETag
W/"5e2ddeec-211f"
Transfer-Encoding
chunked
Content-Type
application/javascript
Cache-Control
max-age=31536000, public
Expires
Tue, 09 Mar 2021 17:22:17 GMT
iab_consent_sdk.v1.0.js
live.sekindo.com/content/ClientDetections/ Frame 2E2F
19 KB
6 KB
Script
General
Full URL
https://live.sekindo.com/content/ClientDetections/iab_consent_sdk.v1.0.js
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx /
Resource Hash
a3336e3373c170b40764f5a62d121335bec4243b0034e561937194dfe2e413fd

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Last-Modified
Wed, 12 Feb 2020 15:01:36 GMT
Server
nginx
ETag
W/"5e441350-4be0"
Transfer-Encoding
chunked
Content-Type
application/javascript
Cache-Control
max-age=31536000, public
Expires
Tue, 09 Mar 2021 17:22:17 GMT
DetectGDPR.v1.0.js
live.sekindo.com/content/ClientDetections/ Frame 2E2F
7 KB
3 KB
Script
General
Full URL
https://live.sekindo.com/content/ClientDetections/DetectGDPR.v1.0.js
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx /
Resource Hash
993ebc45d9927d420801f05819222e8cc1aa523187e4c0b290df02b23ce18093

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Last-Modified
Sun, 26 Jan 2020 11:58:14 GMT
Server
nginx
ETag
W/"5e2d7ed6-1d87"
Transfer-Encoding
chunked
Content-Type
application/javascript
Cache-Control
max-age=31536000, public
Expires
Tue, 09 Mar 2021 17:22:17 GMT
hls.0.12.4_1.min.js
live.sekindo.com/content/video/hls/ Frame 2E2F
247 KB
85 KB
Script
General
Full URL
https://live.sekindo.com/content/video/hls/hls.0.12.4_1.min.js
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx /
Resource Hash
7d0492c66125b1c2bdc419641e41542857e7d90e323d355ee0b8bb268da121fb

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Last-Modified
Mon, 06 Jan 2020 15:31:55 GMT
Server
nginx
ETag
W/"5e1352eb-3dcb9"
Transfer-Encoding
chunked
Content-Type
application/javascript
Cache-Control
max-age=31536000, public
Expires
Tue, 09 Mar 2021 17:22:17 GMT
prebidVid.2.44.3_2.min.js
live.sekindo.com/content/prebid/ Frame 2E2F
267 KB
99 KB
Script
General
Full URL
https://live.sekindo.com/content/prebid/prebidVid.2.44.3_2.min.js
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx /
Resource Hash
4ee36d77a67f176a8468c3fafd5c230a2b8584293b81221b004619e700f84106

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Last-Modified
Thu, 30 Jan 2020 06:21:36 GMT
Server
nginx
ETag
W/"5e3275f0-42b3f"
Transfer-Encoding
chunked
Content-Type
application/javascript
Cache-Control
max-age=31536000, public
Expires
Tue, 09 Mar 2021 17:22:17 GMT
liveVideo.php
live.sekindo.com/live/ Frame 2E2F
391 KB
109 KB
Script
General
Full URL
https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveView.php?s=91975&cbuster=1331262953&pubUrl=https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell&x=350&y=291&vp_content=plembed90jwrxvpntgh&vp_template=123&cbuster=1583774537&pubUrlAuto=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&videoType=normal
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx / PHP/7.3.14
Resource Hash
556009e84d77e4eef550aade1aac3ac405c3090b18805b0fef41db4beb85da83

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Server
nginx
X-Powered-By
PHP/7.3.14
Transfer-Encoding
chunked
Content-Type
text/html; charset=UTF-8
apstag.js
c.amazon-adsystem.com/aax2/ Frame 2E2F
87 KB
25 KB
Script
General
Full URL
https://c.amazon-adsystem.com/aax2/apstag.js
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.222.153.241 Seattle, United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-52-222-153-241.fra53.r.cloudfront.net
Software
Server /
Resource Hash
ac2a58f9d55c4642121cfb6f7e213cbc882bbdd75ef171ca8a07ed982ef693ce

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Sun, 08 Mar 2020 22:00:54 GMT
content-encoding
gzip
server
Server
age
69682
etag
1dcfbf3986ee8b9c3abbc67eb808ab43
x-cache
Hit from cloudfront
content-type
application/javascript
status
200
cache-control
public, max-age=86400
x-amz-cf-pop
FRA53
accept-ranges
bytes
x-amz-cf-id
Nxtq7mzheFjNDLg79Eq-LzsbkD9I7U7trYfiYz-Al3W60InWiuX0Fw==
via
1.1 4d1cbe225c5d30aa78ec9a6fa1ba4211.cloudfront.net (CloudFront)
i
ipds.adrta.com/ Frame 2E2F
Redirect Chain
  • https://adrta.com/i?clid=pms&paid=pms&publisherId=23475&caid=&plid=&siteId=91975&kv1=400x300&kv2=exceljet.net&kv3=5e667b49b8f3f&kv4=83.97.23.3&kv5=chrome&kv11=17026449045e667b49b9676&kv12=91975&kv1...
  • https://ipds.adrta.com/i?__x=NHCQNCIKDI@ECIFILHFHLHPMNKILKLOM@HMNILLLLHOIKI@HMHHOMIGMEMKGMNLAFJPJLNLKIMFMJ@HKJILIHPJLJLHMHINFGCGKMHONILKNGJHCG@GCF&clid=pms&paid=pms&publisherId=23475&caid=&plid=&si...
0
86 B
Image
General
Full URL
https://ipds.adrta.com/i?__x=NHCQNCIKDI@ECIFILHFHLHPMNKILKLOM@HMNILLLLHOIKI@HMHHOMIGMEMKGMNLAFJPJLNLKIMFMJ@HKJILIHPJLJLHMHINFGCGKMHONILKNGJHCG@GCF&clid=pms&paid=pms&publisherId=23475&caid=&plid=&siteId=91975&kv1=400x300&kv2=exceljet.net&kv3=5e667b49b8f3f&kv4=83.97.23.3&kv5=chrome&kv11=17026449045e667b49b9676&kv12=91975&kv15=DE&kv16=&kv17=&kv18=&kv19=&kv24=desktop&kv26=macosx&kv27=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.73.223.232 Ashburn, United States, ASN14618 (AMAZON-AES, US),
Reverse DNS
ec2-52-73-223-232.compute-1.amazonaws.com
Software
Apache/2.4.39 (Amazon) OpenSSL/1.0.2k-fips /
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

status
200
date
Mon, 09 Mar 2020 17:22:18 GMT
server
Apache/2.4.39 (Amazon) OpenSSL/1.0.2k-fips
content-length
0

Redirect headers

status
302
date
Mon, 09 Mar 2020 17:22:18 GMT
server
Apache/2.4.39 (Amazon) OpenSSL/1.0.2k-fips
content-length
0
location
https://ipds.adrta.com/i?__x=NHCQNCIKDI@ECIFILHFHLHPMNKILKLOM@HMNILLLLHOIKI@HMHHOMIGMEMKGMNLAFJPJLNLKIMFMJ@HKJILIHPJLJLHMHINFGCGKMHONILKNGJHCG@GCF&clid=pms&paid=pms&publisherId=23475&caid=&plid=&siteId=91975&kv1=400x300&kv2=exceljet.net&kv3=5e667b49b8f3f&kv4=83.97.23.3&kv5=chrome&kv11=17026449045e667b49b9676&kv12=91975&kv15=DE&kv16=&kv17=&kv18=&kv19=&kv24=desktop&kv26=macosx&kv27=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36
truncated
/ Frame 2E2F
217 B
0
Image
General
Full URL
data:truncated
Protocol
DATA
Server
-, , ASN (),
Reverse DNS
Software
/
Resource Hash
de4b3da818369d0bf3415259dcb5ec7021229f42d496464d11a3772e5b195df8

Request headers

User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Content-Type
image/png
aps_csm.js
c.amazon-adsystem.com/bao-csm/aps-comm/ Frame 2E2F
6 KB
3 KB
XHR
General
Full URL
https://c.amazon-adsystem.com/bao-csm/aps-comm/aps_csm.js
Requested by
Host: c.amazon-adsystem.com
URL: https://c.amazon-adsystem.com/aax2/apstag.js
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
52.222.153.241 Seattle, United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-52-222-153-241.fra53.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
06b99248a163333e36980a6cfb756f1a7de60fa49517162b87b1a44d5d48f844

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

date
Mon, 09 Mar 2020 08:42:31 GMT
content-encoding
gzip
vary
Origin
age
31187
x-cache
Hit from cloudfront
status
200
access-control-allow-origin
*
last-modified
Thu, 05 Mar 2020 08:28:46 GMT
server
AmazonS3
access-control-max-age
3000
access-control-allow-methods
GET
content-type
application/javascript
via
1.1 ec6662ba477736a13086dd664a1145be.cloudfront.net (CloudFront)
cache-control
public, max-age=86400
x-amz-cf-pop
FRA53
x-amz-cf-id
FpCT6pKrwf9AKZLiRxeWahR8FD7KlJ_qK8i_56Naqap2VjvmbpHfPA==
css
fonts.googleapis.com/ Frame 6F6C
2 KB
684 B
Stylesheet
General
Full URL
https://fonts.googleapis.com/css?family=Roboto&display=swap
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:819::200a Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
ESF /
Resource Hash
00d4fbacbadc6ecbd73be323ec77febf3d856ce00dc5334d06462a315c7da8e7
Security Headers
Name Value
Strict-Transport-Security max-age=31536000
X-Content-Type-Options nosniff
X-Frame-Options SAMEORIGIN
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

strict-transport-security
max-age=31536000
content-encoding
gzip
x-content-type-options
nosniff
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
x-xss-protection
0
last-modified
Mon, 09 Mar 2020 17:22:18 GMT
server
ESF
date
Mon, 09 Mar 2020 17:22:18 GMT
x-frame-options
SAMEORIGIN
content-type
text/css; charset=utf-8
access-control-allow-origin
*
cache-control
private, max-age=86400, stale-while-revalidate=604800
timing-allow-origin
*
link
<https://fonts.gstatic.com>; rel=preconnect; crossorigin
expires
Mon, 09 Mar 2020 17:22:18 GMT
css
fonts.googleapis.com/ Frame FF27
2 KB
638 B
Stylesheet
General
Full URL
https://fonts.googleapis.com/css?family=Roboto&display=swap
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:819::200a Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
ESF /
Resource Hash
00d4fbacbadc6ecbd73be323ec77febf3d856ce00dc5334d06462a315c7da8e7
Security Headers
Name Value
Strict-Transport-Security max-age=31536000
X-Content-Type-Options nosniff
X-Frame-Options SAMEORIGIN
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
style

Response headers

strict-transport-security
max-age=31536000
content-encoding
gzip
x-content-type-options
nosniff
status
200
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
x-xss-protection
0
last-modified
Mon, 09 Mar 2020 17:22:18 GMT
server
ESF
date
Mon, 09 Mar 2020 17:22:18 GMT
x-frame-options
SAMEORIGIN
content-type
text/css; charset=utf-8
access-control-allow-origin
*
cache-control
private, max-age=86400, stale-while-revalidate=604800
timing-allow-origin
*
link
<https://fonts.gstatic.com>; rel=preconnect; crossorigin
expires
Mon, 09 Mar 2020 17:22:18 GMT
vid5d87c1e876ba5530585771.jpg
video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/ Frame 6F6C
13 KB
14 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/vid5d87c1e876ba5530585771.jpg?cbuster=1569178272
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
3cfdf8f8972a722aeab1b9563c48d17ba31ff998fdd4b70440bfdc7151252b8a
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://amli.sekindo.com/
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Sun, 22 Sep 2019 18:52:27 GMT
Server
Tengine
ETag
"5d87c2eb-3579"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
13689
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5d87c1e876ba5530585771.jpg
video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/ Frame FF27
13 KB
14 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/vid5d87c1e876ba5530585771.jpg?cbuster=1569178272
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
3cfdf8f8972a722aeab1b9563c48d17ba31ff998fdd4b70440bfdc7151252b8a
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Sun, 22 Sep 2019 18:52:27 GMT
Server
Tengine
ETag
"5d87c2eb-3579"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
13689
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5d87c1e61656b737939630.jpg
video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/ Frame FF27
13 KB
13 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/vid5d87c1e61656b737939630.jpg?cbuster=1569178088
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
250fce16adf97abddfeddcc02fc36d051095ec2781d92788e94ba9f18cd9ac03
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Sun, 22 Sep 2019 18:49:24 GMT
Server
Tengine
ETag
"5d87c234-3306"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
13062
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5aeb106215c30456525974.jpg
video.sekindo.com/uploads/cn7/video/users/converted/23475/video1524477339/ Frame FF27
21 KB
22 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn7/video/users/converted/23475/video1524477339/vid5aeb106215c30456525974.jpg?cbuster=1525354597
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
4c1f15e60bb7727e72578875d3e212441d29ec8873870316de88f0bc3b6ec37a
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Wed, 03 Apr 2019 14:19:46 GMT
Server
Tengine
ETag
"5ca4c102-55a4"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
21924
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5d87c07475f2b530401087.jpg
video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/ Frame FF27
9 KB
9 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/vid5d87c07475f2b530401087.jpg?cbuster=1569177888
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
474df88516dab7c98e73338c3e08fbd23f8a5ea43a9e5997e498b3b4fa4dca75
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Sun, 22 Sep 2019 18:45:24 GMT
Server
Tengine
ETag
"5d87c144-23d6"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
9174
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5aeb105e33403846140879.jpg
video.sekindo.com/uploads/cn7/video/users/converted/23475/video1524477339/ Frame FF27
16 KB
16 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn7/video/users/converted/23475/video1524477339/vid5aeb105e33403846140879.jpg?cbuster=1525354594
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
3d240083c72588b91274e52d37783862a82dbc86031afa83e079274e2b7b11b9
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Wed, 03 Apr 2019 14:19:45 GMT
Server
Tengine
ETag
"5ca4c101-3feb"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
16363
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5afbf5452d36c481630117.jpg
video.sekindo.com/uploads/cn6/video/users/converted/23475/video1524477339/ Frame FF27
13 KB
13 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn6/video/users/converted/23475/video1524477339/vid5afbf5452d36c481630117.jpg?cbuster=1526461780
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
6f0c2ccb6ebc6a58555f30f395934cbcb4dbbc3bcd9a1993bd51ba0fbcceb032
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Wed, 03 Apr 2019 14:50:45 GMT
Server
Tengine
ETag
"5ca4c845-3452"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
13394
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5d87536442204716268419.jpg
video.sekindo.com/uploads/cn9/video/users/converted/23475/video_5d8752d689834989903506/ Frame FF27
12 KB
13 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn9/video/users/converted/23475/video_5d8752d689834989903506/vid5d87536442204716268419.jpg?cbuster=1569150003
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
554b0b4f10a0475a6ef3e6f8566e29f528093f33be1e9adf69823bd92a433a95
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Sun, 22 Sep 2019 11:00:33 GMT
Server
Tengine
ETag
"5d875451-31d3"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
12755
Expires
Thu, 31 Dec 2037 23:55:55 GMT
vid5d87c1e2a1dcc363666881.jpg
video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/ Frame FF27
24 KB
25 KB
Image
General
Full URL
https://video.sekindo.com/uploads/cn8/video/users/converted/23475/video_5d8752d689834989903506/vid5d87c1e2a1dcc363666881.jpg?cbuster=1569178084
Requested by
Host: exceljet.net
URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.127.16.51 London, United Kingdom, ASN210329 (CLOUDWEBMANAGE-UK-1, GB),
Reverse DNS
Software
Tengine /
Resource Hash
f0ba8b12b74d335470137b69b5dc04791e302825ff52ef00fd859aa8859c2f11
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Date
Mon, 09 Mar 2020 17:21:57 GMT
Last-Modified
Sun, 22 Sep 2019 18:48:36 GMT
Server
Tengine
ETag
"5d87c204-619c"
X-Cache-Status
HIT
Strict-Transport-Security
max-age=31536000
Content-Type
image/jpeg
Cache-Control
max-age=315360000
Connection
keep-alive
Accept-Ranges
bytes
Keep-Alive
timeout=25
Content-Length
24988
Expires
Thu, 31 Dec 2037 23:55:55 GMT
truncated
/ Frame 6F6C
2 KB
0
Image
General
Full URL
data:truncated
Protocol
DATA
Server
-, , ASN (),
Reverse DNS
Software
/
Resource Hash
9d02d662da8a47fb5fb610b545007507b6017028043dbb63cd09ec897d3b9627

Request headers

User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Content-Type
image/png
truncated
/ Frame 6F6C
715 B
0
Image
General
Full URL
data:truncated
Protocol
DATA
Server
-, , ASN (),
Reverse DNS
Software
/
Resource Hash
5a3f1dd74233f605e511f1b5b244bedf85ac88ba264caf4d6401bc7ec2017dcd

Request headers

User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Content-Type
image/png
liveView.php
live.sekindo.com/live/ Frame 2E2F
23 KB
2 KB
XHR
General
Full URL
https://live.sekindo.com/live/liveView.php?s=58057&vid_vastTimeout=-1&vid_vastType=3&vid_playerVer=3.0.0&vid_viewabilityState=1&vid_playbackMethod=auto&vid_content_url=https%3A%2F%2Fvideo.sekindo.com%2Fuploads%2Fcn8%2Fvideo%2Fusers%2Fconverted%2F23475%2Fvideo_5d8752d689834989903506%2Fvid5d87c1e876ba5530585771.mp4&vid_content_id=524809&vid_content_desc=How+to+add+unique+count+to+a+pivot+table&vid_content_title=How+to+add+unique+count+to+a+pivot+table&vid_content_duration=207&debugInformation=ABT%20/%20layouts%20/%206%20/%20newInfra&x=380&y=214&fpl=2&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&isApp=0&geoLati=52.51959991455078&geoLong=13.406900405883789&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&csuuid=5e667b49b8f3f&cbuster=1583774538031&gdpr=1&gdprConsent=&isWePassGdpr=0&gdpr2Consent=&isWePassGdpr2=0
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx / PHP/7.3.14
Resource Hash
4b1138bd11405ff28da4eea3fef93c68a95394c09d3429c23178cd7bb932afde

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Pragma
no-cache
Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Server
nginx
Age
0
X-Powered-By
PHP/7.3.14
P3P
CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
Access-Control-Allow-Origin
https://exceljet.net
Cache-Control
no-store
Access-Control-Allow-Credentials
true
Content-Type
application/json; charset=utf-8
Content-Length
1837
liveView.php
live.sekindo.com/live/ Frame 2E2F
7 KB
2 KB
XHR
General
Full URL
https://live.sekindo.com/live/liveView.php?s=58057&vid_vastTimeout=-1&vid_vastType=3&vid_playerVer=3.0.0&vid_viewabilityState=0&vid_playbackMethod=auto&vid_content_url=https%3A%2F%2Fvideo.sekindo.com%2Fuploads%2Fcn8%2Fvideo%2Fusers%2Fconverted%2F23475%2Fvideo_5d8752d689834989903506%2Fvid5d87c1e876ba5530585771.mp4&vid_content_id=524809&vid_content_desc=How+to+add+unique+count+to+a+pivot+table&vid_content_title=How+to+add+unique+count+to+a+pivot+table&vid_content_duration=207&debugInformation=ABT%20/%20layouts%20/%206%20/%20newInfra&x=380&y=214&fpl=2&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&isApp=0&geoLati=52.51959991455078&geoLong=13.406900405883789&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&csuuid=5e667b49b8f3f&cbuster=1583774538032&gdpr=1&gdprConsent=&isWePassGdpr=0&gdpr2Consent=&isWePassGdpr2=0
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/live/liveVideo.php?vpaidManager=sekindo&s=58057&ri=6C69766553746174737C736B317B54307D7B64323032302D30332D30395F31397D7B73393430363530367D7B4335377D7B535A58686A5A5778715A585175626D56307D7B626368726F6D657D7B716465736B746F707D7B6F6D61636F73787D7B583335307D7B593239317D7B66317D7B7251554A5549433867624746356233563063794176494459674C7942755A58644A626D5A7959513D3D7D7B4C3132337DFEFE&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_5%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F74.0.3729.169+Safari%2F537.36&playerVersion=3.0.0&fpl=-1&debugInformation=ABT+%2F+layouts+%2F+6+%2F+newInfra&isWePassGdpr=0&csuuid=5e667b49b8f3f&debugInfo=9406506_ABT+%2F+layouts+%2F+6+%2F+newInfra&debugPlayerSession=&sta=9406506&showLogo=0&clkUrl=&plMult=-1&schedule=eyJwcmVfcm9sbCI6MSwibWlkX3JvbGwiOltdLCJnYXAiOiJhdXRvIn0%3D&content=plembed90jwrxvpntgh&secondaryContent=&x=350&y=291&pubUrl=https%3A%2F%2Fexceljet.net%2Fformula%2Fsum-if-cell-contains-text-in-another-cell&contentNum=1&flow_closeBtn=0&flowCloseTimeout=0&flow_direction=bl&flow_horizontalOffset=10&flow_bottomOffset=100&impGap=2&flow_width=310&flow_height=260&videoType=normal&gdpr=1&gdprConsent=&contentFeedId=&geoLati=52.51959991455078&geoLong=13.406900405883789&vpTemplate=123&flowMode=below&isRealPreroll=0&playerApiId=&isApp=0&gdpr2Consent=&ccpa=0&ccpaConsent=
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx / PHP/7.3.14
Resource Hash
a58b4bfc45f3c1994d61d205c42864560354de922b591653c36bc6dbd086a659

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Pragma
no-cache
Date
Mon, 09 Mar 2020 17:22:17 GMT
Content-Encoding
gzip
Server
nginx
Age
0
X-Powered-By
PHP/7.3.14
P3P
CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
Access-Control-Allow-Origin
https://exceljet.net
Cache-Control
no-store
Access-Control-Allow-Credentials
true
Content-Type
application/json; charset=utf-8
Content-Length
1415
openrtb
ads.adaptv.advertising.com/rtb/ Frame 2E2F
0
213 B
XHR
General
Full URL
https://ads.adaptv.advertising.com/rtb/openrtb?ext_id=PrimisHB
Requested by
Host: live.sekindo.com
URL: https://live.sekindo.com/content/prebid/prebidVid.2.44.3_2.min.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
3.126.20.131 Frankfurt am Main, Germany, ASN16509 (AMAZON-02, US),
Reverse DNS
ec2-3-126-20-131.eu-central-1.compute.amazonaws.com
Software
adaptv/1.0 /
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Content-Type
text/plain

Response headers

Access-Control-Allow-Origin
https://exceljet.net
Access-Control-Allow-Credentials
true
Server
adaptv/1.0
Connection
keep-alive
Content-Length
0
Content-Type
application/json
sodar
pagead2.googlesyndication.com/getconfig/
7 KB
5 KB
XHR
General
Full URL
https://pagead2.googlesyndication.com/getconfig/sodar?sv=200&tid=gpt&tv=2020030501&st=env
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_rendering_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81f::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
cafe /
Resource Hash
f3d1d49218fcc6ca05e316b7cb02e1a5410c763f3bb9080d135ca9d362c8b3be
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Origin
https://exceljet.net
Sec-Fetch-Dest
empty
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

timing-allow-origin
*
date
Mon, 09 Mar 2020 17:22:18 GMT
content-encoding
gzip
x-content-type-options
nosniff
server
cafe
status
200
p3p
policyref="https://www.googleadservices.com/pagead/p3p.xml", CP="NOI DEV PSA PSD IVA IVD OTP OUR OTR IND OTC"
access-control-allow-origin
*
cache-control
private
content-disposition
attachment; filename="f.txt"
content-type
application/json; charset=UTF-8
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
5171
x-xss-protection
0
sodar2.js
tpc.googlesyndication.com/sodar/
14 KB
5 KB
Script
General
Full URL
https://tpc.googlesyndication.com/sodar/sodar2.js
Requested by
Host: securepubads.g.doubleclick.net
URL: https://securepubads.g.doubleclick.net/gpt/pubads_impl_rendering_2020030501.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:814::2001 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
a47f17d6ebbf4621d8fe87ab790d8d8fb5c3086629194d9ff2d64faaa6e46ab6
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
script

Response headers

date
Mon, 09 Mar 2020 17:22:18 GMT
content-encoding
gzip
x-content-type-options
nosniff
server
sffe
etag
"1582746470043195"
vary
Accept-Encoding
content-type
text/javascript
status
200
cache-control
private, max-age=3000
accept-ranges
bytes
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
5456
x-xss-protection
0
expires
Mon, 09 Mar 2020 17:22:18 GMT
runner.html
tpc.googlesyndication.com/sodar/sodar2/209/ Frame 8648
0
0
Document
General
Full URL
https://tpc.googlesyndication.com/sodar/sodar2/209/runner.html
Requested by
Host: tpc.googlesyndication.com
URL: https://tpc.googlesyndication.com/sodar/sodar2.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:814::2001 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

:method
GET
:authority
tpc.googlesyndication.com
:scheme
https
:path
/sodar/sodar2/209/runner.html
pragma
no-cache
cache-control
no-cache
upgrade-insecure-requests
1
user-agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
sec-fetch-dest
iframe
accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
sec-fetch-site
cross-site
sec-fetch-mode
navigate
referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
accept-encoding
gzip, deflate, br
accept-language
en-US
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell

Response headers

status
200
accept-ranges
bytes
vary
Accept-Encoding
content-encoding
gzip
content-type
text/html
content-length
5727
date
Mon, 09 Mar 2020 16:25:20 GMT
expires
Tue, 09 Mar 2021 16:25:20 GMT
last-modified
Tue, 25 Feb 2020 17:32:01 GMT
x-content-type-options
nosniff
server
sffe
x-xss-protection
0
cache-control
public, max-age=31536000
age
3418
alt-svc
quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000
gen_204
pagead2.googlesyndication.com/pagead/
0
64 B
Image
General
Full URL
https://pagead2.googlesyndication.com/pagead/gen_204?id=sodar2&v=209&t=2&li=gpt_2020030501&jk=2229587217246988&bg=!9vWl9e1YS8k7QTotKrsCAAAATlIAAAAOmQFY1lK4dvnVdKboXIaUVV5EfFG7fL8mEsfvxQ8yMkd9ZsocwvgqULnl5m49b4uppgP82yjdwBlYDHOMndvX_kDFNXFgTaqpwyxkJ9HCVo1_6E-EInnR_MzvxxKizxi7mdpUgBdoWO8JQhS24hf_Y6rKrdnZdD-1pNL1zd4Kp-0ukuD3cGEu2Tjbmk-8NJ8KxepDuSTKrxXzuhqpUwI_dXT7QuTLCL90kdrb4aHlbUHTzHZpjx1mWKKeUiwsZGnhfAUYIojgd_vVbhjr4_5kwkyPAi62Skg8CkNvEz32ZDAFHVMr2pKK72Zw6m-VUxaO2qcRQzgBIRjQdaZfpMrJjIZmgWEl2UdIpfVRG16dsugQUJ2bLarPpmGDOl1SjBbdjpqJwK93ZV8yHa_HPixDdcPyhf5TWcvD466a1jTyhQyKOUpziygsU5P8cfcQA5wbx0ziqWktP8yS9kY
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:81f::2002 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
cafe /
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

pragma
no-cache
date
Mon, 09 Mar 2020 17:22:18 GMT
x-content-type-options
nosniff
content-type
image/gif
server
cafe
p3p
policyref="https://www.googleadservices.com/pagead/p3p.xml", CP="NOI DEV PSA PSD IVA IVD OTP OUR OTR IND OTC"
status
204
cache-control
no-cache, must-revalidate
timing-allow-origin
*
alt-svc
quic="googleads.g.doubleclick.net:443"; ma=2592000; v="46,43",quic=":443"; ma=2592000; v="46,43",h3-Q050="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q049="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043="googleads.g.doubleclick.net:443"; ma=2592000,h3-Q043=":443"; ma=2592000
content-length
0
x-xss-protection
0
expires
Fri, 01 Jan 1990 00:00:00 GMT
sync
ups.analytics.yahoo.com/ups/55953/ Frame 2E2F
Redirect Chain
  • https://match.adsrvr.org/track/cmf/generic?ttd_pid=adaptv&ttd_tpi=1
  • https://match.adsrvr.org/track/cmb/generic?ttd_pid=adaptv&ttd_tpi=1
  • https://pixel.advertising.com/ups/55953/sync?uid=2153cf4a-3440-4faf-b8d8-b296c9311e79&_origin=1&gdpr=1&gdpr_consent=&piggybackCookie=2153cf4a-3440-4faf-b8d8-b296c9311e79
  • https://ups.analytics.yahoo.com/ups/55953/sync?uid=2153cf4a-3440-4faf-b8d8-b296c9311e79&_origin=1&gdpr=1&gdpr_consent=&piggybackCookie=2153cf4a-3440-4faf-b8d8-b296c9311e79&apid=UP87a8b363-622a-11ea...
0
989 B
Image
General
Full URL
https://ups.analytics.yahoo.com/ups/55953/sync?uid=2153cf4a-3440-4faf-b8d8-b296c9311e79&_origin=1&gdpr=1&gdpr_consent=&piggybackCookie=2153cf4a-3440-4faf-b8d8-b296c9311e79&apid=UP87a8b363-622a-11ea-b292-020e693014ec
Protocol
HTTP/1.1
Security
TLS 1.3, , AES_256_GCM
Server
18.156.0.31 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
ec2-18-156-0-31.eu-central-1.compute.amazonaws.com
Software
ATS/7.1.2.102 /
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Date
Mon, 09 Mar 2020 17:22:19 GMT
Server
ATS/7.1.2.102
Connection
keep-alive
Age
0
Strict-Transport-Security
max-age=31536000
P3P
CP=NOI DSP COR LAW CURa DEVa TAIa PSAa PSDa OUR BUS UNI COM NAV

Redirect headers

status
302
date
Mon, 09 Mar 2020 17:22:19 GMT
strict-transport-security
max-age=31536000
content-length
0
location
https://ups.analytics.yahoo.com/ups/55953/sync?uid=2153cf4a-3440-4faf-b8d8-b296c9311e79&_origin=1&gdpr=1&gdpr_consent=&piggybackCookie=2153cf4a-3440-4faf-b8d8-b296c9311e79&apid=UP87a8b363-622a-11ea-b292-020e693014ec
p3p
CP=NOI DSP COR LAW CURa DEVa TAIa PSAa PSDa OUR BUS UNI COM NAV
sync
sync.adaptv.advertising.com/ Frame 2E2F
Redirect Chain
  • https://sync-tm.everesttech.net/upi/pid/m7y5t93k?redir=https%3A%2F%2Fsync.adap.tv%2Fsync%3Ftype%3Dgif%26key%3Dtubemogul%26uid%3D%24%7BUSER_ID%7D
  • https://sync-tm.everesttech.net/ct/upi/pid/m7y5t93k?redir=https%3A%2F%2Fsync.adap.tv%2Fsync%3Ftype%3Dgif%26key%3Dtubemogul%26uid%3D%24%7BUSER_ID%7D&_test=XmZ7SwAAAE8A4lk2
  • https://sync.adap.tv/sync?type=gif&key=tubemogul&uid=XmZ7SwAAAE8A4lk2&_test=XmZ7SwAAAE8A4lk2
  • https://sync.adaptv.advertising.com/sync?type=gif&key=tubemogul&uid=XmZ7SwAAAE8A4lk2&_test=XmZ7SwAAAE8A4lk2
10 B
118 B
Image
General
Full URL
https://sync.adaptv.advertising.com/sync?type=gif&key=tubemogul&uid=XmZ7SwAAAE8A4lk2&_test=XmZ7SwAAAE8A4lk2
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
35.168.89.112 Ashburn, United States, ASN14618 (AMAZON-AES, US),
Reverse DNS
ec2-35-168-89-112.compute-1.amazonaws.com
Software
ribs2.0 /
Resource Hash
42e2bdfb6f2641ab97b6a586c31e591246a5240bc86e504d6ec02c616aeb8e4e

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Server
ribs2.0
Connection
keep-alive
Content-Length
10
Content-Type
text/plain

Redirect headers

Location
//sync.adaptv.advertising.com/sync?type=gif&key=tubemogul&uid=XmZ7SwAAAE8A4lk2&_test=XmZ7SwAAAE8A4lk2
Server
ribs2.0
Connection
keep-alive
Content-Length
0
Content-Type
text/plain
%7Bcombo_uid%7D
pr-bh.ybp.yahoo.com/sync/adaptv_ortb/ Frame 2E2F
43 B
779 B
Image
General
Full URL
https://pr-bh.ybp.yahoo.com/sync/adaptv_ortb/%7Bcombo_uid%7D
Protocol
H2
Security
TLS 1.2, ECDHE_RSA, AES_128_GCM
Server
2a00:1288:110:c305::8000 , United Kingdom, ASN34010 (YAHOO-IRD, GB),
Reverse DNS
Software
ATS /
Resource Hash
48a33ca9f42b91902d57ad8ac52e1ce32b92c8c10c732f2dbb6fe960ebfd9438
Security Headers
Name Value
Strict-Transport-Security max-age=31536000
X-Content-Type-Options nosniff
X-Xss-Protection 1; mode=block

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

date
Mon, 09 Mar 2020 17:22:19 GMT
referrer-policy
strict-origin-when-cross-origin
server
ATS
age
0
expect-ct
max-age=31536000, report-uri="http://csp.yahoo.com/beacon/csp?src=yahoocom-expect-ct-report-only"
strict-transport-security
max-age=31536000
content-type
image/gif
status
200
x-content-type-options
nosniff
content-length
43
x-xss-protection
1; mode=block
expires
Thu, 01 Jan 1970 00:00:00 GMT
sync
ups.analytics.yahoo.com/ups/57304/ Frame 2E2F
Redirect Chain
  • https://cm.g.doubleclick.net/pixel?google_nid=adaptv_dbm&google_cm&google_sc
  • https://cm.g.doubleclick.net/pixel?google_nid=adaptv_dbm&google_cm=&google_sc=&google_tc=
  • https://pixel.advertising.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1
  • https://pixel.advertising.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&verify=true
  • https://ups.analytics.yahoo.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&apid=UP87a8b363-622a-11ea-b292-020e693014ec
  • https://ups.analytics.yahoo.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&apid=UP87a8b363-622a-11ea-b292-020e693014ec&verify=true
0
977 B
Image
General
Full URL
https://ups.analytics.yahoo.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&apid=UP87a8b363-622a-11ea-b292-020e693014ec&verify=true
Protocol
HTTP/1.1
Security
TLS 1.3, , AES_256_GCM
Server
18.156.0.31 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
ec2-18-156-0-31.eu-central-1.compute.amazonaws.com
Software
ATS/7.1.2.102 /
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
Security Headers
Name Value
Strict-Transport-Security max-age=31536000

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Date
Mon, 09 Mar 2020 17:22:19 GMT
Server
ATS/7.1.2.102
Connection
keep-alive
Age
0
Strict-Transport-Security
max-age=31536000
P3P
CP=NOI DSP COR LAW CURa DEVa TAIa PSAa PSDa OUR BUS UNI COM NAV

Redirect headers

Date
Mon, 09 Mar 2020 17:22:19 GMT
Server
ATS/7.1.2.102
Age
0
Strict-Transport-Security
max-age=31536000
P3P
CP=NOI DSP COR LAW CURa DEVa TAIa PSAa PSDa OUR BUS UNI COM NAV
Location
https://ups.analytics.yahoo.com/ups/57304/sync?uid=CAESELTyPO6X9QrD0ELqfOOCQ5Y&google_cver=1&apid=UP87a8b363-622a-11ea-b292-020e693014ec&verify=true
Connection
keep-alive
Content-Length
0
showad.js
ads.pubmatic.com/AdServer/js/ Frame F041
0
0
Document
General
Full URL
https://ads.pubmatic.com/AdServer/js/showad.js
Requested by
Host: exceljet.net
URL: https://exceljet.net/prebid.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
23.210.249.92 , Netherlands, ASN16625 (AKAMAI-AS, US),
Reverse DNS
a23-210-249-92.deploy.static.akamaitechnologies.com
Software
Apache/2.2.15 (CentOS) /
Resource Hash

Request headers

Host
ads.pubmatic.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_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
Sec-Fetch-Site
cross-site
Sec-Fetch-Mode
navigate
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Accept-Encoding
gzip, deflate, br
Accept-Language
en-US
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell

Response headers

Last-Modified
Tue, 04 Feb 2020 05:12:07 GMT
ETag
"13006b6-9f85-59db914d12ccf"
Server
Apache/2.2.15 (CentOS)
Accept-Ranges
bytes
Content-Encoding
gzip
P3P
CP="NOI DSP COR LAW CUR ADMo DEVo TAIo PSAo PSDo IVAo IVDo HISo OTPo OUR SAMo BUS UNI COM NAV INT DEM CNT STA PRE LOC", CP="NOI DSP COR LAW CUR ADMo DEVo TAIo PSAo PSDo IVAo IVDo HISo OTPo OUR SAMo BUS UNI COM NAV INT DEM CNT STA PRE LOC"
Content-Length
14955
Content-Type
text/html; charset=UTF-8
Cache-Control
public, max-age=77319
Expires
Tue, 10 Mar 2020 14:50:59 GMT
Date
Mon, 09 Mar 2020 17:22:20 GMT
Connection
keep-alive
Vary
Accept-Encoding
async_usersync.html
acdn.adnxs.com/ib/static/usersync/v3/ Frame DA1D
0
0
Document
General
Full URL
https://acdn.adnxs.com/ib/static/usersync/v3/async_usersync.html
Requested by
Host: exceljet.net
URL: https://exceljet.net/prebid.js
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
23.210.249.83 , Netherlands, ASN16625 (AKAMAI-AS, US),
Reverse DNS
a23-210-249-83.deploy.static.akamaitechnologies.com
Software
nginx/1.9.13 /
Resource Hash

Request headers

Host
acdn.adnxs.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_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
Sec-Fetch-Site
cross-site
Sec-Fetch-Mode
navigate
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
Accept-Encoding
gzip, deflate, br
Accept-Language
en-US
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
iframe
Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell

Response headers

Last-Modified
Fri, 20 May 2016 02:07:09 GMT
ETag
"573e714d-3e3"
Server
nginx/1.9.13
Content-Type
text/html
Vary
Accept-Encoding
Access-Control-Allow-Origin
*
Content-Encoding
gzip
Content-Length
506
Cache-Control
max-age=31536000
Expires
Tue, 09 Mar 2021 17:22:20 GMT
Date
Mon, 09 Mar 2020 17:22:20 GMT
Connection
keep-alive
sync
staging-aws-fr.bidswitch.net/
Redirect Chain
  • https://x.bidswitch.net/sync?ssp=iow_labs
  • https://x.bidswitch.net/ul_cb/sync?ssp=iow_labs
  • https://bsw.digitru.st/syncx?ssp=iow_labs&bsw_own_uuid=1104abde-90f4-4b60-a2ba-b828a0396545
  • https://staging-aws-fr.bidswitch.net/sync?ssp=iow_labs&bsw_own_uuid=1104abde-90f4-4b60-a2ba-b828a0396545
43 B
315 B
Image
General
Full URL
https://staging-aws-fr.bidswitch.net/sync?ssp=iow_labs&bsw_own_uuid=1104abde-90f4-4b60-a2ba-b828a0396545
Protocol
HTTP/1.1
Security
TLS 1.3, , AES_256_GCM
Server
52.57.255.4 Frankfurt am Main, Germany, ASN16509 (AMAZON-02, US),
Reverse DNS
ec2-52-57-255-4.eu-central-1.compute.amazonaws.com
Software
nginx /
Resource Hash
548f2d6f4d0d820c6c5ffbeffcbd7f0e73193e2932eefe542accc84762deec87

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36

Response headers

Date
Mon, 09 Mar 2020 17:22:20 GMT
Cache-Control
no-cache, no-store, must-revalidate
Server
nginx
Connection
keep-alive
P3P
CP="NOI DSP COR NID CURa ADMa DEVa PSAa PSDa OUR BUS COM INT OTC PUR STA"
Content-Length
43
Content-Type
image/gif

Redirect headers

status
302
date
Mon, 09 Mar 2020 17:22:20 GMT
cache-control
no-cache, no-store, must-revalidate
content-length
0
location
//staging-aws-fr.bidswitch.net/sync?ssp=iow_labs&bsw_own_uuid=1104abde-90f4-4b60-a2ba-b828a0396545
p3p
CP="NOI DSP COR NID CURa ADMa DEVa PSAa PSDa OUR BUS COM INT OTC PUR STA"
liveView.php
live.sekindo.com/live/ Frame FF27
0
379 B
Image
General
Full URL
https://live.sekindo.com/live/liveView.php?njs=1&ito=1&vid_event=25&serverTime=1583774537&s=91975&sta=0&x=350&y=291&vid_passDomain=exceljet.net&subId=exceljet.net&debugInformation=ABT%20%2F%20layouts%20%2F%206%20%2F%20newInfra&userIpAddr=83.97.23.3&userUA=Mozilla%2F5.0%20%28Macintosh%3B%20Intel%20Mac%20OS%20X%2010_14_5%29%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Chrome%2F74.0.3729.169%20Safari%2F537.36&csuuid=5e667b49b8f3f&contentFileId=0&mediaPlayListId=0&dur=1000&cbuster=1583774548020&gdpr=1&gdprConsent=&isWePassGdpr=0&gdpr2Consent=&isWePassGdpr2=0&ccpa=0&ccpaConsent=
Protocol
HTTP/1.1
Security
TLS 1.2, ECDHE_RSA, AES_256_GCM
Server
185.220.204.204 Amsterdam, Netherlands, ASN41436 (CLOUDWEBMANAGE-EU, GB),
Reverse DNS
Software
nginx / PHP/7.3.14
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

Request headers

Referer
https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell
User-Agent
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
Sec-Fetch-Dest
image

Response headers

Pragma
no-cache
Date
Mon, 09 Mar 2020 17:22:27 GMT
Content-Encoding
gzip
Server
nginx
Age
0
X-Powered-By
PHP/7.3.14
Transfer-Encoding
chunked
P3P
CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
Access-Control-Allow-Origin
*
Cache-Control
no-store
Content-Type
text/html; charset=UTF-8

Verdicts & Comments Add Verdict or Comment

56 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.

object| onformdata object| onpointerrawupdate object| Drupal undefined| $ function| jQuery string| GoogleAnalyticsObject function| ga object| FORMALIZE object| apstag number| adsStart function| detectWidth function| detectPage function| doDisplay number| TIMEOUT object| googletag object| pbjs object| adUnits object| a9Slots boolean| a9BidsBack string| device string| pageType function| initAdServer string| dfpNetwork object| mapping number| len object| google_tag_data object| gaplugins object| gaGlobal object| gaData boolean| apstagLOADED function| pbjsChunk object| dfpAdunitsToRefresh object| _pbjsGlobals object| __core-js_shared__ object| ggeac object| closure_memoize_cache_ object| googleToken object| googleIMState object| google_js_reporting_queue function| processGoogleToken number| google_srt undefined| google_measure_js_timing number| __google_ad_urls_id number| google_unique_id function| Goog_AdSense_getAdAdapterInstance function| Goog_AdSense_OsdAdapter object| __google_ad_urls object| ampInaboxIframes object| ampInaboxPendingMessages boolean| google_osd_loaded boolean| google_onload_fired function| Goog_Osd_UnloadAdBlock function| Goog_Osd_UpdateElementToMeasure function| google_osd_amcb object| GoogleGcLKhOms object| google_image_requests

0 Cookies

2 Console Messages

Source Level URL
Text
console-api log URL: https://exceljet.net/formula/sum-if-cell-contains-text-in-another-cell(Line 208)
Message:
BDS back 417 [object Object],[object Object],[object Object]
console-api log URL: https://exceljet.net/prebid.js(Line 4)
Message:
Adunit is now viewable div-gpt-ad-EJ_Leaderboard_Pos1

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
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.

aax-eu.amazon-adsystem.com
acdn.adnxs.com
adrta.com
ads.adaptv.advertising.com
ads.pubmatic.com
adservice.google.com
adservice.google.de
bsw.digitru.st
c.amazon-adsystem.com
cm.g.doubleclick.net
exceljet.net
fonts.googleapis.com
fonts.gstatic.com
grid.bidswitch.net
hbopenbid.pubmatic.com
ib.adnxs.com
ipds.adrta.com
live.sekindo.com
match.adsrvr.org
pagead2.googlesyndication.com
pixel.advertising.com
pr-bh.ybp.yahoo.com
securepubads.g.doubleclick.net
staging-aws-fr.bidswitch.net
sync-tm.everesttech.net
sync.adap.tv
sync.adaptv.advertising.com
tpc.googlesyndication.com
ups.analytics.yahoo.com
video.sekindo.com
www.google-analytics.com
www.googletagservices.com
x.bidswitch.net
151.101.114.49
172.217.23.130
18.156.0.31
18.197.186.176
185.127.16.51
185.220.204.204
185.64.189.112
216.58.210.2
23.210.249.83
23.210.249.92
2600:3c00::f03c:91ff:fee7:ea6e
2a00:1288:110:c305::8000
2a00:1450:4001:814::2001
2a00:1450:4001:819::200a
2a00:1450:4001:81a::2002
2a00:1450:4001:81d::2003
2a00:1450:4001:81f::2002
2a00:1450:4001:821::200e
3.126.20.131
3.248.119.92
35.168.89.112
37.252.173.38
52.0.180.19
52.222.153.241
52.57.106.47
52.57.255.4
52.59.36.197
52.73.223.232
52.94.216.48
54.93.38.91
00d4fbacbadc6ecbd73be323ec77febf3d856ce00dc5334d06462a315c7da8e7
0482a98d09daebc18a0d2e1ed8f748da5b0179e61223ed541101df1f4699f073
064872df0a883f87da4059702facdd9bb92ec344f54a5cd23c3d0d01fe631893
06b99248a163333e36980a6cfb756f1a7de60fa49517162b87b1a44d5d48f844
110233d13f03c7bc071c69fbbf5d97739f0c3f97bdf78b260b51c5a324c3c5af
1232908a9ba85dce548fdd54ee669e64bbfd1c112f3e422b063ea49c2360e90a
1f3c3d147b2fa11fa2d0e1593e15c52d2b13d76d69383cabf108a33169866146
24f53dcd8de26fb9ab9f8d1aa300da21f3395be6c9afc19f6da852498877d955
250fce16adf97abddfeddcc02fc36d051095ec2781d92788e94ba9f18cd9ac03
260171d80a7a81fd41f597f03a4b67ae702cbb95f6f5c2e0af625df0d9853ede
2b0ff00e38503e45bea7e8a0ef4c5ceff0b45d562182a47b7a80a936150ec228
2d1a1e169b7a4da51417cc2f5d7383985686e3f8a9393b60378218ecb421bed8
3123803590a098de112d9c726301c2a6a9b8fcdbaa771ebf6fc494cedb6087bf
3166174f1e7ecea7f03d1d7abaf045f167639d65ca9272e68c2666ae2758e5e0
3cfdf8f8972a722aeab1b9563c48d17ba31ff998fdd4b70440bfdc7151252b8a
3d240083c72588b91274e52d37783862a82dbc86031afa83e079274e2b7b11b9
3dfc7f57df739ac6410ddf0791b80fe55de158c52c294b46046f4366f35e043e
40ba9d6ba2e284332ccfba657abb51667c07b4077fa3dc79ae7741d1c2dd1dc1
42842c4928fd167ff3cb57a681061cc609ff70b25f836395da313a26456e1820
42e2bdfb6f2641ab97b6a586c31e591246a5240bc86e504d6ec02c616aeb8e4e
44136fa355b3678a1146ad16f7e8649e94fb4fc21fe77e8310c060f61caaff8a
474df88516dab7c98e73338c3e08fbd23f8a5ea43a9e5997e498b3b4fa4dca75
48a33ca9f42b91902d57ad8ac52e1ce32b92c8c10c732f2dbb6fe960ebfd9438
4b1138bd11405ff28da4eea3fef93c68a95394c09d3429c23178cd7bb932afde
4c1f15e60bb7727e72578875d3e212441d29ec8873870316de88f0bc3b6ec37a
4dec34f15f11fb4fc32f79b6523ff698e29f1e2a920db975387439ea9c0f2fa6
4ee36d77a67f176a8468c3fafd5c230a2b8584293b81221b004619e700f84106
548f2d6f4d0d820c6c5ffbeffcbd7f0e73193e2932eefe542accc84762deec87
554b0b4f10a0475a6ef3e6f8566e29f528093f33be1e9adf69823bd92a433a95
556009e84d77e4eef550aade1aac3ac405c3090b18805b0fef41db4beb85da83
5573981c1e5d9480d150362b9b86ac3fe85f8754783ff6bf4d65f38243e7ce07
57e02d12f57f9d16696ee0f9c9232e575c8dcb6943c90a3c502dc827cd8fd94f
5a3f1dd74233f605e511f1b5b244bedf85ac88ba264caf4d6401bc7ec2017dcd
62bbfded3a2fcb9a24f8b9eb62b5e23a70c52513edaba6529e2cb8cc2257bd6b
641a429af68a7a10b8527a4fd2d5fdcc30715b300224f3ebc50d2b7df7926fea
65b9332bcc97c85599a5b847df94c4e09e5622aa9880e0664ffa048cd52145ff
66d5e6dbe8e34aca82d039e6ffe9a3a753246921c37ddc49c6f054b41ca42037
6d6cd55572e8be7aa03c122e0ef98bf72d91a2caa2dddfe3c7c5b50f67d2bd07
6f0c2ccb6ebc6a58555f30f395934cbcb4dbbc3bcd9a1993bd51ba0fbcceb032
76cc10f394bbfba4764735523d77180052bf5a9ca9a0b1a83a5b8a99f498bf3b
7d0492c66125b1c2bdc419641e41542857e7d90e323d355ee0b8bb268da121fb
8337212354871836e6763a41e615916c89bac5b3f1f0adf60ba43c7c806e1015
89532fca3a8c3cc19bf2374c14cec90cf905a3cf2e10723a2cf3868b49c6f54c
8ee04e0441c9e51785d17ac835a93cf4d30d90826f87350b42ba233496a26f55
8f56b300fb05dc7a5a1fda67ec43a1302773da6fb5fd62b78b4ada7fb3eecb44
912856e113e646cb59dd2a480be66f5463455408b458432e0a7234664608685c
993ebc45d9927d420801f05819222e8cc1aa523187e4c0b290df02b23ce18093
99bd5fdbaf99e0ba6351497460030a7d18a9ef8451c799680bcf9c7f5cbda8dd
9d02d662da8a47fb5fb610b545007507b6017028043dbb63cd09ec897d3b9627
9e2495c161431efc3c941e8bf3ed90b308c32fe1951ee614306ada5a230bc797
a3336e3373c170b40764f5a62d121335bec4243b0034e561937194dfe2e413fd
a376fd6a6def28335937568b481ee1cdb83d6291c10fc3c31d91c06719a7bd84
a47f17d6ebbf4621d8fe87ab790d8d8fb5c3086629194d9ff2d64faaa6e46ab6
a58b4bfc45f3c1994d61d205c42864560354de922b591653c36bc6dbd086a659
a6d4756636677b193c823d90f6622033633feb3b51e1c90afa2ffa83316694d3
a75a7bf10f415b7c91f0b959177f3f1779e78cbf735601e41fb982c2b1cf4be2
ac2a58f9d55c4642121cfb6f7e213cbc882bbdd75ef171ca8a07ed982ef693ce
ace61d80f3fe90bbb02ab328d9705b57a9c8a95d3a0bf6b4cd510d4dacd033df
ad689e708d79b668d9056b458ad9597f0745c63e28b153f1edd6a120daceb218
adb1572725320d91a3293d898fc40e41b5951de36c38e28b50756a1f50eb0c06
adb1f13a956435c141cc1f14708e47d6fd5d820c207b726185127a82460138d7
b599918c6e69885715973620b0279bc23dbee5b1be558345ca5c55c25623bf3e
b8b7d1f10441c7349e88ed2a168e0635836f6724999f91ea8d15ecd4811dad38
b8d0e162509a6196e3c2c0f0feb37761671d04542568b021adba8db1aaab1029
bb0adf04e242155ab8da6b93323aead9b0fe45487c34dabf7d94536fa76c35be
c36349b9ad5c541d7b374602e747ba952da9fc4b33d6f6df4df395c795dc834a
c8cb742dbb60decab090cf738bfef2d8a780141573e9a2a3854bf3f78919faed
cc35096cc15a7da250a25ef8a716492998336b2a782559f0c51b8150c0560768
ccd60a06b60160dc987d719bccb83804a4e054797be513bf039c0b1353a31c17
d3b9ac60281114eb252c949187818336066886576d5fc78f31cc8c4c2d94531f
d451dbf5f8193ed939f4869e89b619d302726f1468b2eada55dc73aff3f49065
d858f18810e152dab30d63b3f99cf2384de3c18fff18695189223b146f893c58
de4b3da818369d0bf3415259dcb5ec7021229f42d496464d11a3772e5b195df8
e233e023875f13d3815c8234bfb61b18ca25e8731222cb009896c70e8457d102
e395b2755b3c8428d5ba113344b48715853a831c88424b7f7e2ec142ab761069
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
e55af38d89fc4cb497fc8ce7dfd41c14316d6c95ea48a49181aec65d7566f605
eaf1b128b927ac2868755cb7366d35554255c8af362235afe270f9614f8c806d
f0ba8b12b74d335470137b69b5dc04791e302825ff52ef00fd859aa8859c2f11
f3d1d49218fcc6ca05e316b7cb02e1a5410c763f3bb9080d135ca9d362c8b3be
ffdc18ac8f47bcd50dd9c33532c334e7073717a62b367d95b9cb1561048547dc