Help with Sumproduct

[helpme290]

Hello all,

I have provided the spreadsheet that I need help on.

Within the sheet named "tab" I want to use the formula Sum-product as a check to a specific set of numbers. I provided the objective of the exercise within the Spreadsheet in the sheet name "tab". I feel that it is easier to understand when you see the file.

https://www.dropbox.com/s/lqwxk8lqpx...lp.2.xlsx?dl=0

All of your help is greatly appreciated!!

 

[smallxyz]

Hello all,

I have provided the spreadsheet that I need help on.

Within the sheet named "tab" I want to use the formula Sum-product as a check to a specific set of numbers. I provided the objective of the exercise within the Spreadsheet in the sheet name "tab". I feel that it is easier to understand when you see the file.

https://www.dropbox.com/s/lqwxk8lqpx...lp.2.xlsx?dl=0

All of your help is greatly appreciated!!

Hi, helpme290. I am a bit lost.
Could you elaborate more on your desired purpose?

 

[helpme290]

HI smallxyz

I want to see if my totals within the sheet named "tab" are correct and tie out to the the sheet named "Number"

 

[smallxyz]

HI smallxyz

I want to see if my totals within the sheet named "tab" are correct and tie out to the the sheet named "Number"

Using array function in SUMPRODUCT? Umm, I am not so skillful in utilizing that procedure.

But here are two alternatives just figured out:

1.　for an accurate retrieval of data, VLOOKUP may guarantee the result.

2.　Or, if for a pure purpose of checking, DSUM may also be applicable.
Database: Columns "Number","2013","2014","2015" from "Number Sheet"
Field:　input 3 for summing data of 2013, 4 for 2014, 5 for 2015
Criteria: field column "Number" from "Tab Sheet" being criteria　( The header "Number" has to be included" )

And then compare the returned results with Tab sheet's ones.

 

[Michael M]

How about a simple plain english explanation, what you require ??
Maybe SUMPRODUCT is not required !!....maybe it is !!