sumif 2 criteria
This is probably very simple but I am having problem writing the sumif
formuala. The range I want to add up is AJ99:Aj3467 if f36 = d99:d3467 and if g36 = b99:3467 |
Hi Doug
what do you mean by if F36=D99:D3467 (and the same for the other condition) generally the solution to a multiple criteria SUMIF is a SUMPRODUCT, e.g. =SUMPRODUCT((A1:A100="Jan")*(B1:B100="Fred")*(C1:C 100)) ie sum the values in column C where Jan occurs in column A & Fred occurs in column B but i don't understand your criteria so i can't generate the actual formula for you but hopefully this will put you on the right track to a solution. Regards JulieD PS do you mean =SUMPRODUCT((d99:d3467=F36)*(b99:b3467=G36)*(AJ99: AJ3467 )) "Doug" wrote in message ... This is probably very simple but I am having problem writing the sumif formuala. The range I want to add up is AJ99:Aj3467 if f36 = d99:d3467 and if g36 = b99:3467 |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com