SUMPRODUCT Or SUMIF - In case of Case sensitive???

I need some assistance on calculating the SUM in Column F if the Products in cells B2 to B10000 are case sensitive.

In other words, Column B has products GingerA and Gingera, while column F has the quantity. The 2 products are actually different and so I want to sum them seprately. I'm not suer how to do this, and if I could use EXACT with a sumif or sumproduct to do this...

My current formula is: =IF(B2=B3,"",SUMIF($B$2:$B$10000,B2,$F$2:$F$10000))

Please help!

Thanks in advance!

Thank you for a quick reply

Somehow, this is not throwing back any values...all "0" only.

My data is not in chrno order and has alpha numeric values will that matter?

Also what about the IF condition in my previous formula, will that become redunant?

=IF(B2=B3,""...

Please advise...

Thanks again!

I'm not at my system, but my mind is still there...I'll try to explain (if it doesn't help, will upload a file asap).

Basically, I'm sorting the data using the product names in column B and, then using =if(B2=B3,"",sumif(....))

So the IF is being used to test if B2=B3, my guess with the array would be that it is no longer required including the sorting of the data. Correct?

Also, I came across a weired scenario when I sorted my data to check against the already done piece (manual) the sorting when tested with the exact function returned "false". I manually ran through the data and found all the products were present but somehow, mine returned GingerA in B76 andd Gingera in B77, but then on sorting the manual version of the data it returned Gingera in B76 and GingerA in B77.

I'm not sure if am missing a trick here or if the excel is miss-behaving

Please advise...

=SUMPRODUCT(--(ISNUMBER(FIND(D2,$B$2:$B$1000))),$F$2:$F$1000) where d2 holds gingerA
or
=SUMPRODUCT(--(ISNUMBER(FIND("GingerA",$B$2:$B$1000))),$F$2:$F$1000)
FIND() is case sensitive

Thanks a bunch Martin! It worked perfectly!

Cheers!

Thanks Norie for all your help. IT worked:-). You guys are just magical

@ eisayew

Thanks. I'm sorted on this one. You guys rock!!!