SUMIF?? for combination text-numeric greater than a certain number

I am trying to figure out how to sum visits for various browser sizes. The browser sizes are displayed in a combination of text and number (eg, 600x1200). I want to count any visits with a screen size above 1000 (either height or width). Anyone know how to do this?

See attached.

Welcome to the Forum.
Please don't upload images as images are not very helpful and don't expect anybody to type the data shown in the image into the excel sheet on your behalf.

Try this...... (not tested but arrange the data as per the ranges in the formula and test the formula to see whether you get the desired result.)

Assuming your Browser Sizes are in the range B4:B13 and Visits are in the range C4:C13 (as per your example image), then

=SUMPRODUCT(--(LEFT(B4:B13,FIND("x",B4:B13)-1)*1>1000),C4:C13)+SUMPRODUCT(--(RIGHT(B4:B13,LEN(B4:B13)-FIND("x",B4:B13))*1>1000),C4:C13)

Is this what you are trying to achieve?

Took data from A1 to B3 in my sample.

Formula:

=SUMPRODUCT(((LEFT(A1:A3,FIND("x",A1:A3,1)-1)*1>1000))*(B1:B3))+SUMPRODUCT(((MID(A1:A3,(FIND("x",A1:A3)+1),LEN(A1:A3))*1)>1000)*(B1:B3))

Control+Shift+Enter

Oh yes. I didn't consider that what if both the height and width are greater than 1000 in a single cell? Very good pick...
In that case try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter. (i.e. after placing the formula in the cell hold down the Ctrl+Shift and then press Enter and if you paste the formula in the cell, first press F2 (function key) and then hold down Ctrl+Shift and then press Enter.)

=SUMPRODUCT(IF((LEFT(B4:B13,FIND("x",B4:B13)-1)*1>1000)+(RIGHT(B4:B13,LEN(B4:B13)-FIND("x",B4:B13))*1>1000),1,0)*C4:C13)

See if you get the desired result.

Here is a solution for you that takes the list of browser sizes and if there are duplicates creates a list of unique sizes and gives the total for all browser sizes that have a dimension of 1000 or more in either length, width or both.

The solution uses a helper column to determine the dimensions and returns. I used text values to make it obvious what the results were. You might prefer something else:

lessless if both dimensions are < 1000
lessgreater if the first dimension is less than 1000 and the second dimension is >=1000
greaterless if the first dimension is >1000 and second dimension is <1000
greatergreater if both dimensions >=1000

Helper column:

Formula:

=IF(--LEFT(B4,SEARCH("x",B4)-1)<1000,"less","greater")&IF(--(RIGHT(B4,LEN(B4)-SEARCH("x",B4))*1>=1000),"greater","less")

Unique browser sizes:

Formula:

=IFERROR(INDEX($B$4:$B$20,MATCH(1,INDEX((COUNTIF($H$1:H3,$B$4:$B$20)=0)*($B$4:$B$20<>""),0),0)),"")

Count for browsers with a dimension >=1000

Formula:

=IF(H4<>"",SUMPRODUCT(($B$4:$B$20=H4)*($D$4:$D$20={"lessgreater","greaterless","greatergreater"})*$C$4:$C$20),"")

Conditional formatting hides 0 values