Best way to add multiple IF formulas.

[Cgalla87]

Hello,

I am developing a Full Time Employee Headcount tracker for my business. Looking for ideas on best way to add multiple IF formulas. For example, I have a table that has employee name and salary. Next to it I run out 36 months. If that employee is still employed there is a 1 in each of the 36 months, if they left our company it switches to a 0. Now for each month I want to add the total salaries of the company (but ONLY if they are still employed).

Right now I have a bunch of IF(A1>0,A2,0)+IF(B1>0,B2,0)+.....so on for every employee row. obviously, as the company grows I don’t want to have hundreds of IF statements added together. Any thoughts on best way to add individual cells if a different cell in that row is above 0?

Hope that made sense.

 

[Joe4]

Without seeing your data, it is hard to say. But in looking at your formula, I am guessing that SUMIF may be what you want, i.e.

=SUMIF(A1:Z1,">0",A2:Z2)

See here for more details on the SUMIF function: MS Excel: How to use the SUMIF Function (WS)

 

[tyija1995]

Hey,

I'd try a SUMPRODUCT formula.

=SUMPRODUCT((A1:AJ1)*(A2:AJ2))

Assuming your 36 columns are spanned from A to AJ

 

[Cgalla87]

Thanks all!

 

[Joe4]

Thanks all!

You are welcome.
Glad we were able to help!