Forum Discussion
Amateur Excel, please help!
Hey there- I'm an amateur excel user who needs some major help! I'm trying to pull out data from an aging report. Some names are exactly the same. So what I am trying to do is pull out data from...
See the attached demo workbook. I used SUMPRODUCT formulas.
Hi Hans, I am unable to download the workbook.. Is there any way you could enter the formulas in the response?
The formula in C16 is =SUMPRODUCT(C$2:C$11*(LEFT($B$2:$B$11)<="H"))
In C17: =SUMPRODUCT(C$2:C$11*(LEFT($B$2:$B$11)>="I")*(LEFT($B$2:$B$11)<="Q"))
In C18: =SUMPRODUCT(C$2:C$11*(LEFT($B$2:$B$11)>="R"))
These can be filled to the right to column F.