Sum with Criteria

[junmacs]

hi guys,

I'm trying to get the total of each personnel with the criteria off D an N using this formula {=SUM(C8:BB8,$BC$7,$C$7:$BB$7)}, but it is not getting the exact total using the criteria "D" and "N".

Please help.

[AliGW]

You need this for D:

=SUMIF($C$7:$BB$7,$BC$7,$C8:$BB8)

and this for N:

=SUMIF($C$7:$BC$7,$BC$7,$C8:$BB8)

These are ordinary formulae entered with ENTER (not C+S+E).

[oeldere]

AI32 looks the right answer to me.

I advice you not to work with merged cells, you get in troubel with it sooner on later.

[junmacs]

thank you

[AliGW]

You're welcome!