Formula Help

[kiamm]

Hello All,

I've been trying to find a formula that will sum certain criteria and
haven't been able to get the correct results, please someone let m
know what I'm doing wrong.

Example:

I have a one year calendar and on this year to date calendar I want t
keep track of certain time off (vac, sick, personal etc...)

In cell L27 is V and in cell M27 is 8, meaning this person too
Vacation time and used 8 hours. This continues through out and ends a
cel BU27. ex. ( N27=V, O27=8) (P27=S, Q27=8).


The formula that I've tried is SUMIF(L27:BU27,"V",L27:BU27)

This is giving me a value and not calculating correctly.

I want the formula to look up columns L27:BU27 and if they are = to "V
then I want it to sum 1 column over to the right (ex. above if L27 =
then sum M27= 8) and so on but it's not doing this.

PLEASE HELP!!!!

 

[Frank Kabel]

Hi
try the following formula
=SUMPRODUCT(--(N27:BU27="V"),O27:BV27)

 

[kiamm]

THANKS SO MUCH....... THAT DID IT.........

*Hi
try the following formula
=SUMPRODUCT(--(N27:BU27="V"),O27:BV27)

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag