sum the value which have multiple criteria accross columns(horizontally)

[Raghava@rock]

Hi Team,
Need help in Sum the value with multiple criteria across columns.
Attached is the sample file.
Looking forward for response.

 

[NARAYANK991]

Hi ,

See the file for one method.

Narayan

 

[Hui]

Criteria 1
I assume is >=24/4/15 & <=3/9/15 & RAG_1
G14: =SUMPRODUCT((D5: P 5="RAG_1")*(C4:O4>=A2)*(C4:O4<=A3)*(D6: P 10))
=120

Criteria 2
I assume is <24/4/15 & RAG_1
G15: =SUMPRODUCT((D5 : P 5="RAG_1")*(C4:O4<A2)*(D6 : P 10))
=90

 

[Hui]

If I have misread your question then the combined result is similar to Narayan's

Except my formula sums all the rows
=SUMPRODUCT((D5: P 5="RAG_1")*(C4: O 4<A2)*(D6: P 10))
=90

For a single row
=SUMPRODUCT((D5: P 5="RAG_1")*(C4: O 4<A2)*(D6: P 6))
=6