CODEWITHSUNDEEP
excelformattingsumifs
HigHendHd
HigHendHd

Reputation: 59

Excel SUMIFS over a range of number formatted as text

I am currently working on an Excel Sheet with thousands of entries.

In one of the columns all the numbers are stored as text. I want to make a SUMIFS over those entries, but it does not seem no work because of the wrong formatting. Is there any way to calculate my results without changing the original data?

Thanks

Upvotes: 0

Views: 1723

Answers (1)

Brian
Brian

Reputation: 2108

You could use this as an array formula (press ctrl + shft + enter):

=SUM(IF(B1:B5="d",NUMBERVALUE(A1:A5)))

Or, as a regular formula:

=SUMPRODUCT((B1:B5="d")*(C1:C5="g"),NUMBERVALUE(A1:A5))

Upvotes: 1

Related Questions