=SUMPRODUCT((TRIM(A2:A22)={"sewage","sweet","garbage"})*(B2:B22))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Thursday, July 12, 2012 6:51 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macro
So exactly what you are looking for? A drop down list to show the total in
adjacent column?
I have created a dropdown, if you looking for somthing else, then please
explain a bit more
On Thu, Jul 12, 2012 at 5:21 PM, Mohammed Muneer wrote:
> Thanx *Noor *for this also,
>
> But I need to c
Thanx Noor for this also,
But I need to change the description in same cell to get individual
total.
Sewage/Sweet/Garbage all this totals from one cell.
Hope u understand this time.
Regards,
Muneer,
CC...
see attached sheet.
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI
wrote:
Dear Mune
PFA
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI wrote:
> see attached sheet.
>
>
> On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Muneer,
>>
>> Please use below formula
>>
>> =SUMPRODUCT((A2:A8=D5)*(B2:B8))
>>
>> or
>>
>> =Sumif(A2:A8,d5,B2:B8)
>>
>>
>> On Thu, Jul 12, 20
Dear friends,
I want to call a function/formula here that show me the sum of the each
item separately from the given descriptions.
Regards,
Muneer,
CC.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
