Posted to microsoft.public.excel.worksheet.functions

Nimish Shah Nimish Shah is offline

external usenet poster

Posts: 1

Excel : Nesting of functions such as sumproduct and sumif

I need guidance to calculate the following which is shown as an excample:-

Qty-Pcs Kg-Each Manufacturer Total kgs(Tom) Total kgs(Harry)

100 1 Tom 100
150 2 Harry 300
50 3 Tom 150
150 4 Harry 600
300 5 Tom 1500

How to calulate in one fuction the following :-
1. Total Kgs-Tom (1750) :
2. Total Kgs-Harry (900) :

Regards,

Nimish Shah

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT + CSE	Epinn	Excel Worksheet Functions	7	November 3rd 06 05:30 PM
Sumproduct (Sumif) with Nested Or Criteria	bkt	Excel Worksheet Functions	9	September 5th 06 06:45 PM
SUMPRODUCT or SUMIF	nfbelo	Excel Worksheet Functions	2	May 24th 05 07:18 PM
SUMPRODUCT or SUMIF or ...	nfbelo	Excel Worksheet Functions	4	May 24th 05 06:34 PM
Sumif not Sumproduct	David	Excel Worksheet Functions	4	December 8th 04 11:39 AM

All times are GMT +1. The time now is 12:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us