IF Formula on Excel 2013 query Hi all, I need some help! Below is a table I\'m c

Question

IF Formula on Excel 2013 query

Hi all,

I need some help!

Below is a table I'm creating for Holiday, Sickness and Unpaid Leave.

I'm trying to do an IF formula whereby if a number 1 is put into Cells B3 to AF3 then '1' is taken off of Cell AG3 and the total holiday's left is changed.

So at the moment I have the formula below in Cell AH3.... =IF(F3=1,AG3-1, AG3-0)

So I've got that sorted for one cell but not all of them, so how can I change it so then it includes Cells B3 to AF3?

Next, I want it so if a number 2 is put into Cells B3 to AF3 then '1' is added to Cell AI3 to calculate Sick Days.

Then, i want it so if a number 3 is put into Cells B3 to AF3 then '1' is added to Cell AJ3 to calculate Unpaid Leave.

Please can somebody help me as I keep getting stuck!!!

Thanks !!

Explanation / Answer

Hi..

Hi,

This in AH3

=AG3-SUMIF(B3:AF3,1)

And this in AJ3

=COUNTIF(B3:AF3,3)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects