Sumifs not work with two critirial

[leakhna]

Hello All,

I try to used sumifs with my reported but it not work.

Example I have code A and Code B, my reported will have ether code A or B, so I want them whatever A or B it must be sum value together.

Please refer to attached file for more detail.

Thanks,
Leakhna

[pjwhitfield]

theres no file

[leakhna]

theres no file

I try to attached but I don't know it is attached or not.

Can you help me.

Thanks

[shayej]

put the following formula in C15 and drag it where to all other cells

Please Login or Register  to view this content.

[leakhna]

put the following formula in C15 and drag it where to all other cells

Please Login or Register  to view this content.

Hello This formula work but I don't to set it by month too, because in reality the month not exactly same so i want the value also appear base on Month.

Thanks,
Leakhna

[FDibbins]

In your sample, you have each month in it's own column. the formula provided give the required answer based on your sample. If your actual data is not like your sample, then please provide a better sample