Hi,
I'm assuming this is a SUMIF query. All I want to do is summarise the sales values by the Bxxx code.
Cheers,
Snook
Hi,
I'm assuming this is a SUMIF query. All I want to do is summarise the sales values by the Bxxx code.
Cheers,
Snook
Last edited by The_Snook; 07-17-2013 at 10:03 AM.
Yep:
=SUMIF($B$3:$B$28,"*"&E3,$C$3:$C$28)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try SumProduct.
Formula:Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Perhaps in F3 and copy down.
=SUMPRODUCT((RIGHT(B3,4)=E3)*($C$3:$C$28))
Edit: Even that problem is solved by excellent way from TMS, of course is my bad and i meaned..
=SUMPRODUCT((RIGHT(B3:B28,4)=E3)*($C$3:$C$28))
Last edited by Fotis1991; 07-17-2013 at 07:31 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
@Fotis: maybe ...
=SUMPRODUCT((RIGHT($B$3:$B$28,4)=$E3)*($C$3:$C$28)) if it is to be dragged down
Regards, TMS
Ha ha. Thank you Trevor! I don't like Dollars.. That's why..I prefer Euros!
That's why..I prefer Euros!
Never thought I'd hear a Greek saying that
Regards, TMS
I know that sounds weird .. but the comparison is between the dollar and Euro.
So if i had only these 2 choices i would prefer Euro and not Dollar!
Fair enough
Sweet solutions all round, thanks!
You're welcome. Thanks for the rep.
You are welcome. Thanks for the rep!
I would like to say that as you have an excellent solution using SUMIF, it's better to avoid the SUMPRODUCT.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks