When I use this formula to return the result of Jan & North which should be 100 , I am getting result for the three instances of North which is 450. I am unable to get the formula to isolate just Jan & North. Does anyone have a suggestion what I should do to get the desired result? Your help is greatly appreciated.
=SUM((B98:B106="Jan"),(C98:C106="North")*D98:D106)
Month Region Sales
Jan North 100
Jan South 200
Jan West 300
Feb North 150
Feb South 250
Feb West 350
Mar North 200
Mar South 300
Mar West 400
Bookmarks