array sumif

Hi all, I am attempting to clean-up one of my dashboards by linking it directly to the source data rather than via an Access database. I have hit a problem with #Value errors from a SUMIFS formula. I have found from reading many threads that this function is not compatible with closed...

Hi people. Thanks again for the help. I'm facing a new problem with a very large sheet. In fact, I want to sum the column "Extension" when a couple of criterias is true, The example: Place Extension Date1 Date2 Date3 Date4...

This is my first thread so go easy on me.. I want to add multiple SUM(SUMIFS(...)) array formulas, without having to manually type SUM(SUMIFS(...))+SUM(SUMIFS(...))+ etc Is there a way to SUM an array of array formulas? ---------------------------------------- My specific example: <tbody>...

Hello, I imagine I'm making a pretty basic mistake, I'm completely self-taught via Google/various forums so my Excel knowledge is less than extensive. I am using an array to sum the amount of work (in hours) completed in any particular week. There are four different types of work listed, each...

I have 3 columns I would like to do an array multiplication formula with an if statement. I have tryed SUMIF and SUMPRODUCT with no luck. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> Column A represents Quantity A5:A5000 <o:p> </o:p> Column B...