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. |
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) |