Working with a Sumifs

I'm working with a sumifs formula that I can seem to get right. If you refer to my attachment this is what I'm working with. In table 1 I have the formula working properly. But I want it to function as desired in table 2. In table 2 I want my sumifs to return the totals from all the values referred in column N in sheet 2.

The table needs the totals from all the values referred in column N not just from one value from column N.

Thank you for any help.

In cell D22....

Formula:

Please Login or Register  to view this content.

Copy and paste from D22 to the whole table D22 to M27...


This is more than just the column you are asking about but is this what you mean?

Unfortunately this method wont work. I cant use the name's to reference. My actual work on this file will return incorrect values. I have to use the sets of the 6000 numbers. In sheet 2 you can see that there is no correlation in columns C & E.

Hi,

Try this formula

=INDEX($D$6:$M$11,MATCH(N23,$N$6:$N$11,0),MATCH($D$19,$D$3:$M$3,0))

Try this
In D22, then drag across

Please Login or Register  to view this content.