Sumif problem

[rubikscube991]

I am Having Certain type of sumif I need to Add Various Sum of various cell in reference to criteria from 1 cell.

Display value 43 in Cell D14 using Sumif formula.
I cannot use "SUM" formula as "Jan" (criteria) is a fixed text in Cell C14, but keeps changing In above table which moves up/down as it is linked to other worksheets.

Columns keep adding for so I have to change formula again and again.

I cannot use pivot due to some issues. Please find the atached sheet.
Thanks in advance!!!.

 

[NARAYANK991]

Hi ,

Is it necessary to use SUMIF ? See the attached file and comment.

Narayan

 

[Somendra Misra]

Hi,

Isn't simply using below formula will fetch you the result:

In D14:

=SUMIF($B$3:$B$10,C14,$G$3:$G$10)

Or am I missing something.

Regards,

 

[udprocks]

Hi,

Isn't simply using below formula will fetch you the result:

In D14:

=SUMIF($B$3:$B$10,C14,$G$3:$G$10)

Or am I missing something.

Regards,

Somendra sir,

you never missed anything here, its simple and cool..

 

[rubikscube991]

thanks guys,

i forgot that i can use lookups and hide the column..actually i just showed Total column for your reference.

god help me. i am growing silly day by day..

 

[Somendra Misra]

Hi,

If Total column is not there than use below formula:

=IFERROR(SUMPRODUCT(VLOOKUP(C14,$B$3:$F$10,{2,3,4,5},0)),0)

Regards,

 

[rubikscube991]

thankyou for ur help

 

[Syedali]

PFA