SUMIFS function

[mmmarks]

Hi folks,
Im trying to use SUMIFS function but it always throwing Value# error .. I think somewhere while selecting range I'm committing the mistake..

I have attached sample data and in Requirement sheet I need output.

Thanks In advance..

[XOR LX]

Hi,

I can't see an attempt at a SUMIF(S) formula anywhere in this book?

Regards

[daddylonglegs]

All ranges in SUMIFs need to be the same size and shape, otherwise you'll get #VALUE! error

Which formula are you trying?

[mmmarks]

my mistake,

actually, there is a sheet called sheet1 . It 's a RAW data and requirement sheet is there where I want to show the values for specific customer under specific month/employee/manager.

In the example, in requirement sheet @ B3, formula should be written. criteria would be A1, B2 and A3 . RAw data for this from sheet1 A1 column to M column.

[mmmarks]

any advice plzzzz

[FDibbins]

Try this in B3 copied down and across...
=SUMIF(Sheet1!$A$3:$A$999,requirement!$A$1,OFFSET(INDIRECT("SHEET1!"&ADDRESS(1,MATCH($A3,Sheet1!$A$1:$U$1,0))),2,MATCH(requirement!B$2,Sheet1!$A$2:$E$2,0)-2))