SUMIF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i noticed that if you have different "range" and "sum range" (different
number of rows in the array i.e i had a "range" from E2:E284 and "sum range"
from H7:H235 ) you get a wrong result, even if the values you want to SUM are
included in both "range" and "sum range"(i.e. they are in row 100 and row 105)
Anyone knows why?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum last 3 numbers greater that 0 in a range 0
SUMIFS for rows 1
SUm function and adding rows 2
SUMIF with multiple columns in sum range 5
Sumif number is greater than a number but less than another number 2
using sumifs with multiple criteria? 3
SUMIF with NAME RANGE 1
How to use Sumifs with vertically and horizontally criterias 1

Back
Top