Thread
:
sumif with 3 condition - urgent
View Single Post
#
5
Posted to microsoft.public.excel.misc
RKS
external usenet poster
Posts: 63
sumif with 3 condition
Thanks. Keep in Mind
"Don Guillett" wrote:
Just a word to the wise. Many of us will ignore "urgent" requests. All
requests get the same priority around here.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RKS" wrote in message
...
Hi all
I have protect excel sheet1, which we have enter data in many column.
I have create another sheet2 for summery. here we have use 2 criteria like
Buyer and mode (ship or air)
its working fine.
C D E
buyer air_qty sea_qty
XX 100 200
In Column D
=SUM(IF('data'!$F$6:$F$115=C2,IF('data'!$AX$6:$AX$ 115="Air",'data'!$L$6:$L$115,0),0))
In Column E
=SUM(IF('data'!$F$6:$F$115=C2,IF('data'!$AX$6:$AX$ 115="Sea",'data'!$L$6:$L$115,0),0))
Its working fine. now I want add another criteria like PM in column B
(Production Manager) and in data sheet
PM column is E.
condition 1. If pm is Nill then sum qty buyerwise and mode wise
respectively
condition 2. if Pm is given and buyer is null then sum Qty PM and Mode
wise
respectively
condition 3. if Pm is given and buyer is given then sum of quantity PM,
buyer and Mode wise
B C D E
pm buyer air_qty sea_qty
XX 100 200
how can change formula or any other ways please help me
Thanks in advance
RKS
Reply With Quote
RKS
View Public Profile
Find all posts by RKS