Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

2012-07-12 Thread dguillett1
=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

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

2012-07-12 Thread Shaik Waheed
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

RE: $$Excel-Macros$$ Sumif / Sumproduct formula required.

2012-07-12 Thread Mohammed Muneer
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

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

2012-07-12 Thread Shaik Waheed
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

$$Excel-Macros$$ Sumif / Sumproduct formula required.

2012-07-12 Thread Mohammed Muneer
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