Search:

Tag: sumproduct

Page 2 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Exclude Zero Value Cells in a Sumproduct Formula calculating every other column

    Started by nmacej‎, 06-15-2010 11:09 PM
    array formulas, exclude columns, exclude value, sumproduct
    • Replies: 3
    • Views: 881
    Last Post: 06-16-2010 03:38 AM
    by DonkeyOte  Go to last post

    Forum:
    Excel Worksheet Functions

  2. Why is my spreadsheet slow! - Arrays?,Named Ranges?,Indirect refs??

    Started by ACN‎, 06-02-2010 06:30 AM
    named ranges, performance, slow, sumproduct
    • Replies: 5
    • Views: 1,009
    Last Post: 06-03-2010 02:04 PM
    by JBeaucaire  Go to last post

    Forum:
    Excel General

  3. Formula for variances

    Started by GarethSteed‎, 05-25-2010 08:22 AM
    formula, sumif, sumproduct, variances
    • Replies: 2
    • Views: 176
    Last Post: 05-27-2010 06:58 AM
    by GarethSteed  Go to last post

    Forum:
    Excel General

  4. SUMPRODUCT with TWO Conditions

    Started by Akarupert‎, 05-24-2010 03:50 PM
    autofilter, list, sumproduct, visible
    • Replies: 2
    • Views: 470
    Last Post: 05-24-2010 05:10 PM
    by Akarupert  Go to last post

    Forum:
    Excel General

  5. [SOLVED] sumproduct with reference to sheet not returning value

    Started by lallo.jr‎, 05-15-2010 02:57 PM
    sumproduct 1 Attachment(s)
    • Replies: 5
    • Views: 239
    Last Post: 05-15-2010 03:30 PM
    by shg  Go to last post

    Forum:
    Excel General

  6. [SOLVED] correct syntax for adding a set of coordinates to a SUMPRODUCT formula

    Started by lallo.jr‎, 05-11-2010 07:25 PM
    arrays, sumproduct, syntax
    • Replies: 2
    • Views: 268
    Last Post: 05-12-2010 12:58 AM
    by lallo.jr  Go to last post

    Forum:
    Excel General

  7. [SOLVED] SUMPRODUCT not recognizing text criteria

    Started by lallo.jr‎, 05-10-2010 11:32 PM
    criteria, dates, sumproduct
    • Replies: 1
    • Views: 361
    Last Post: 05-10-2010 11:42 PM
    by NBVC  Go to last post

    Forum:
    Excel General

  8. Vector Calculations

    Started by dmillier‎, 05-03-2010 05:31 PM
    sumproduct, vector multiplication 2 Attachment(s)
    • Replies: 6
    • Views: 422
    Last Post: 05-08-2010 11:26 AM
    by dmillier  Go to last post

    Forum:
    Excel 2007 Help

  9. SUMPRODUCT total

    Started by bkatzman‎, 04-29-2010 12:15 PM
    functions, sumproduct, total
    • Replies: 3
    • Views: 308
    Last Post: 04-29-2010 12:30 PM
    by NBVC  Go to last post

    Forum:
    Excel 2007 Help

  10. SUMPRODUCT using OR with two or more text strings

    Started by bkatzman‎, 03-31-2010 04:53 PM
    sumproduct, text
    • Replies: 4
    • Views: 271
    Last Post: 03-31-2010 05:54 PM
    by DonkeyOte  Go to last post

    Forum:
    Excel Worksheet Functions

  11. SUMPRODUCT across worksheet not working

    Started by bkatzman‎, 03-31-2010 03:23 PM
    excel, function, sumproduct
    • Replies: 2
    • Views: 158
    Last Post: 03-31-2010 03:31 PM
    by bkatzman  Go to last post

    Forum:
    Excel Worksheet Functions

  12. VBA - Strange behavior with Application.Evaluate and Sumproduct

    Started by largebrick‎, 03-31-2010 07:48 AM
    error 2015, evaluate, sumproduct, vba
    • Replies: 2
    • Views: 809
    Last Post: 03-31-2010 08:04 AM
    by largebrick  Go to last post

    Forum:
    Excel Programming

  13. SUMPRODUCT with Today() and text criteria

    Started by Wkruger‎, 02-19-2010 02:33 PM
    sumproduct, today() 1 Attachment(s)
    • Replies: 5
    • Views: 451
    Last Post: 02-20-2010 11:40 AM
    by Wkruger  Go to last post

    Forum:
    Excel Programming

  14. Multiple Variables - Sumif error

    Started by gustavo.simoes1‎, 11-20-2009 09:31 AM
    sumif, sumproduct 2 Attachment(s)
    • Replies: 8
    • Views: 610
    Last Post: 11-21-2009 09:07 AM
    by gustavo.simoes1  Go to last post

    Forum:
    Excel Worksheet Functions

  15. Sum of Criteria within Date Range

    Started by dmacri‎, 11-19-2009 07:33 PM
    sumif, sumifs, sumproduct 1 Attachment(s)
    • Replies: 3
    • Views: 846
    Last Post: 11-20-2009 02:08 AM
    by Paul  Go to last post

    Forum:
    Excel - New Users

  16. [SOLVED] Sumproduct, excluding some values and adjusting

    Started by Will087‎, 10-21-2009 12:46 PM
    sumproduct 3 Attachment(s)
    • Replies: 7
    • Views: 431
    Last Post: 10-22-2009 10:57 AM
    by Will087  Go to last post

    Forum:
    Excel General

  17. using YEAR and MONTH together

    Started by admiraldick‎, 10-15-2009 12:02 PM
    date, month, sum product, sumproduct, year 1 Attachment(s)
    • Replies: 2
    • Views: 183
    Last Post: 10-16-2009 05:26 AM
    by admiraldick  Go to last post

    Forum:
    Excel General

  18. Sumproduct

    Started by shehankrodrigo‎, 10-09-2009 04:18 AM
    assistance, formula, sumproduct
    • Replies: 1
    • Views: 270
    Last Post: 10-09-2009 09:52 AM
    by NBVC  Go to last post

    Forum:
    Excel - New Users

  19. Need Validation type drop-down wildcard in Sumproduct

    Started by megnin‎, 10-05-2009 04:19 PM
    drop-down, sumproduct, validation, wildcard
    • Replies: 4
    • Views: 688
    Last Post: 10-05-2009 05:44 PM
    by NBVC  Go to last post

    Forum:
    Excel Programming

  20. Need Validation type drop-down wildcard in Sumproduct

    Started by megnin‎, 10-05-2009 04:15 PM
    drop-down, sumproduct, validation, wildcard
    • Replies: 1
    • Views: 163
    Last Post: 10-05-2009 04:37 PM
    by NBVC  Go to last post

    Forum:
    Excel Programming

  21. [SOLVED] Requesting a SUMPRODUCT command that will give a count of rows where all of the follo

    Started by JakePatuli‎, 08-25-2009 04:38 PM
    sumproduct
    • Replies: 5
    • Views: 279
    Last Post: 08-25-2009 05:41 PM
    by DonkeyOte  Go to last post

    Forum:
    Excel General

  22. SUMPRODUCT to count unique values AND more criteria...?

    Started by tangcla‎, 07-29-2009 01:26 AM
    count, criteria, sumproduct, unique
    • Replies: 1
    • Views: 1,390
    Last Post: 07-29-2009 03:42 AM
    by DonkeyOte  Go to last post

    Forum:
    Excel Worksheet Functions

  23. Row count, for multiple criteria, with string search.

    Started by AshJolie‎, 07-20-2009 03:31 PM
    multiple critiria, string match, sumproduct
    • Replies: 1
    • Views: 675
    Last Post: 07-20-2009 03:38 PM
    by NBVC  Go to last post

    Forum:
    Excel Worksheet Functions

  24. [SOLVED] Value error on sumproduct and sum array formula

    Started by judasdac‎, 07-16-2009 12:42 PM
    array, sumif, sumproduct, wrong data type error 1 Attachment(s)
    • Replies: 2
    • Views: 1,381
    Last Post: 07-16-2009 01:38 PM
    by judasdac  Go to last post

    Forum:
    Excel General

  25. Using conditional formatting to highlight a row based on the sumproduct formula

    Started by aaron85‎, 07-08-2009 10:07 AM
    beginner, conditional formatting, countif, sumproduct 1 Attachment(s)
    • Replies: 3
    • Views: 668
    Last Post: 07-09-2009 09:22 AM
    by NBVC  Go to last post

    Forum:
    Excel - New Users

  26. SUMPRODUCT using 2 different date ranges

    Started by PowerSchoolDude‎, 06-22-2009 05:19 PM
    =or, sumproduct 1 Attachment(s)
    • Replies: 6
    • Views: 416
    Last Post: 06-22-2009 06:07 PM
    by PowerSchoolDude  Go to last post

    Forum:
    Excel General

  27. Sum based on partial contents of cells in another collumn

    Started by tpillow‎, 06-09-2009 07:51 AM
    extraction, find, formulas, sumif, sumproduct 1 Attachment(s)
    • Replies: 3
    • Views: 217
    Last Post: 06-09-2009 08:23 AM
    by DonkeyOte  Go to last post

    Forum:
    Excel General

  28. Help with vlookup or sumproduct!

    Started by gwmartins‎, 04-22-2009 02:46 AM
    match, matching columns, sum, sumproduct, vlookup
    • Replies: 2
    • Views: 194
    Last Post: 04-22-2009 11:39 PM
    by gwmartins  Go to last post

    Forum:
    Excel General

  29. Using VBA to enter a SumProduct formula into a cell

    Started by LemonTwist‎, 04-09-2009 10:51 AM
    1004, error, run-time, sumproduct, vba
    • Replies: 1
    • Views: 1,600
    Last Post: 04-09-2009 11:03 AM
    by DonkeyOte  Go to last post

    Forum:
    Excel Programming

  30. How to count rows based on multiple criteria

    Started by jackb1117‎, 03-27-2009 02:52 AM
    count, countif, criteria, help needed, sumproduct 3 Attachment(s)
    • Replies: 4
    • Views: 416
    Last Post: 03-27-2009 09:36 AM
    by DonkeyOte  Go to last post

    Forum:
    Excel Worksheet Functions

  31. SUMIFS forumla into something Excel 03 can handle - work distribution requirement!

    Started by jsbaker88‎, 03-25-2009 07:20 AM
    arrays, compatability, dates formula, sumifs, sumproduct
    • Replies: 3
    • Views: 315
    Last Post: 03-25-2009 12:04 PM
    by DonkeyOte  Go to last post

    Forum:
    Excel 2007 Help

  32. [SOLVED] SUMPRODUCT of columns based on matrix position

    Started by jungpil‎, 03-20-2009 04:52 AM
    matrix, offset, sumproduct 1 Attachment(s)
    • Replies: 5
    • Views: 484
    Last Post: 03-20-2009 11:05 AM
    by DonkeyOte  Go to last post

    Forum:
    Excel General

  33. Sumproduct with conditions?

    Started by voraciousV‎, 02-07-2009 01:42 AM
    conditions, sumproduct
    • Replies: 1
    • Views: 264
    Last Post: 02-07-2009 02:33 AM
    by twaccess  Go to last post

    Forum:
    Excel General

  34. [SOLVED] 3 Conditions - SUMIF or SUMPRODUCT or...?

    Started by Madrabbitwoman‎, 01-06-2009 11:09 AM
    2 Pages •
    1 2
    conditions, date, sumif, sumproduct
    • Replies: 15
    • Views: 1,132
    Last Post: 01-06-2009 01:30 PM
    by Madrabbitwoman  Go to last post

    Forum:
    Excel General

  35. [SOLVED] Sumproduct, skipping columns, addition

    Started by jayclinton‎, 12-29-2008 05:59 PM
    sumproduct
    • Replies: 2
    • Views: 243
    Last Post: 12-29-2008 07:12 PM
    by jayclinton  Go to last post

    Forum:
    Excel General

Results 36 to 70 of 111
Page 2 of 4 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.2.0