Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multi column of sumif
while I create a multi column sumif function as this:
=sumif(a:a,"special",or/and(b:b,d:d,f:f)), but it is unable to function. So, I use the duplicate sumif function like this: =sumif(a:a,"special",b:b)+sumif(a:a,"special",d:d) +sumif(a:a,"special",f:f). Please tell me how to simplify it with thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multi column of sumif
this will work if nothing in col c or e
=SUMPRODUCT((A2:A22="special")*B2:F22) -- Don Guillett SalesAid Software "birdsting" wrote in message ... while I create a multi column sumif function as this: =sumif(a:a,"special",or/and(b:b,d:d,f:f)), but it is unable to function. So, I use the duplicate sumif function like this: =sumif(a:a,"special",b:b)+sumif(a:a,"special",d:d) +sumif(a:a,"special",f:f). Please tell me how to simplify it with thanks. -- birdsting |
#3
|
|||
|
|||
Thanks a lot Mr. Don Guillett for your help!.
Rgds, Birdsting Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Vary column to sum in SumIf | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
help with sumif to calculate column | Excel Discussion (Misc queries) |