CODEWITHSUNDEEP
excelexcel-formula
bizzehdee
bizzehdee

Reputation: 21023

SQL Like formulas in excel

I currently have a small table in excel, and i am looking to create a summary table that displays "total visits with a width over 1024" and "total visits with a width of 1024 and below". But i would like this to operate within a formula as this table will be updated on a weekly basis and i would like a certain amount of the work automated.

Is this possible? i have already looked into =SUMIF, came out all zeros, and i would like to avoid a long string of =IF's.

Table

(Note, i am aware i have spelt height wrong, this is what happens when your messing with google analtytics and excel first thing in the morning)

Upvotes: 0

Views: 286

Answers (1)

Vikas
Vikas

Reputation: 250

Following are the formulas that you can use -

"total visits with a width over 1024"

=SUMIF(B2:A10,">"&1024,E2:E10)

"total visits with a width of 1024 and below"

=SUMIF(B2:A10,"<="&1024,E2:E10)

where B column represents width column and E column represents visits column

Upvotes: 1

Related Questions