issue of sumif when calculating rows

[ganeshm]

Dear experts,

I have used sumif to calculate all recruited people which is denoted as "IN". But sumif formula is not counting all left people which is denoted as "OUT". What is actually am i missing, there?

Regards,
ganeshm

 

[Luke M]

A couple of things.
In your SUMIF, the first range should be range you want to check against criteria. This would be row 3 in your workbook. The formula you could put in col AA:AB would be:
=SUMIF($C$3:$Z$3,AA$3,$C4:$Z4)

This one formula can be used for the IN, OUT, and Total. Although for the Total you can either copy the formula from the left (summing everything in column) or the SUMIF (sum all totals from respective category).

Next issue is the column labels. Some of the columns say "OUT" and some say " OUT" (note the extra space). These need to be corrected.

 

[oldchippy]

Hi ganeshm,

Remove the space before the "spaceOUT"

 

[ganeshm]

thank you luke and old chippy for the quick response and for your input.

I have removed the "spaceOUT".

Regards,
ganesh