Thank you Noorain. I appreciate your help very much.
John
On Wed, Aug 31, 2011 at 1:26 PM, NOORAIN ANSARI wrote:
> Dear john,
>
> Please see attached sheet..
>
> On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith wrote:
>
>> Your help please. I have a log of product sold and need to calculate the
Dear john,
Please see attached sheet..
On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith wrote:
> Your help please. I have a log of product sold and need to calculate the
> different product sold to date, like a running accumulation field specific
> to product listed in column B.
>
> Please see my
Hi john,
Try the Below...
=SUMIF($B$2:$B$8,B2,$D$2:$D$8)
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith wrote:
> Your help please. I have a log of product sold and need to calculate the
> different product sold to date, like a running accumulation field
s@googlegroups.com
> *Subject:* $$Excel-Macros$$ Calculate Product Sold To Date by Product
>
> Your help please. I have a log of product sold and need to calculate
> the different product sold to date, like a running accumulation field
> specific to product listed in col
in d2 copied down
=SUMIF($B$2:B2,B2,$C$2:C2)
From: John A. Smith
Sent: Tuesday, August 30, 2011 11:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculate Product Sold To Date by Product
Your help please. I have a log of product sold and need to calculate the
Your help please. I have a log of product sold and need to calculate the
different product sold to date, like a running accumulation field specific
to product listed in column B.
Please see my attached spreadsheet. Thanking you in advance for all your
great help.
John
--
-
