Flora Edwards
asked on
SUMIFS number stored as text
Hi,
please see attached worksheet. I have SUMIFS formula in Column D and it does not work because Column B data are numbers stored as text. I want help with formula to modify the formula, so that without converting the B column to number, my formula would work.
EE.xlsx
please see attached worksheet. I have SUMIFS formula in Column D and it does not work because Column B data are numbers stored as text. I want help with formula to modify the formula, so that without converting the B column to number, my formula would work.
EE.xlsx
Ca you explain idea of second criteria of your formula?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Patrick and Rgonzo
you guys are heros in EE.
your formulas are amazing. frankly, i am impressed.
you guys are heros in EE.
your formulas are amazing. frankly, i am impressed.
ASKER
these answers are worth 50000.
saved me hours of manual work.
saved me hours of manual work.
Glad to help :)
Also happy to see Rgonzo1971's SUMPRODUCT approach. I tried something similar but couldn't get it to work, and so resorted to the explicit array formula (SUMPRODUCT can be made to work, as Rgonzo1971 ably demonstrated, as an implicit array function).
Also happy to see Rgonzo1971's SUMPRODUCT approach. I tried something similar but couldn't get it to work, and so resorted to the explicit array formula (SUMPRODUCT can be made to work, as Rgonzo1971 ably demonstrated, as an implicit array function).