I am using Excel 2016. I need to create a formula that will provide me with a total of the numbers in the cells in one range that meet the criteria of specific text in a different range. Range X contains the specific text and Range Y contains the numbers that need to be added together if they match the text in Range X. I entered the following formula and received a message of "You've entered to few arguments for this function."

Formula Entered: =SUMIFS(G:G,"Text",E:E,">=1")

I previously asked this question with the following information and examples:

Range X contains the specific text and Range Y contains the numbers that need to be added together if they match the text in Range X.
I tried using SUMPRODUCT as follows but was not successful:
=SUMPRODUCT((RANGE X,"TEXT")*(RANGE Y,"=>1"))
=SUMPRODUCT((RANGE X,"TEXT")*(RANGE Y, =>1))

The feedback I received was as follows:

1. =SUMPRODUCT((B1:B10="TEXT")*(C1:C10>=1))
but you could use countifs
=COUNTIFS(B1:B10,"text",C1:C10,">=1")
mind you this is sum so
=SUMPRODUCT((B1:B10="TEXT")*(C1:C10>=1),c1:c10)
or
=SUMIFS(C1:C10,B1:B10,"text",C1:C10,">=1")

Note: I used the last option and I thought it worked but I can't find my source.

I'd appreciate any thoughts, etc.

JazziML