Holiday spreadsheet - SUMIF forumla no longer works?

C

Custard Tart

I have a holiday spreadsheet that I've used for the last three years
which was passed down to me when I took over this role.

At the top of the spreadsheet, it works out sick days, holiday
allowance, etc. It also works out full days (with the letter H) and
half days (with the letter G). This was the formula that was used:

{=(SUM(IF(C17:D382="g",0.5)))}

The 2010 spreadsheet no longer accepts this formula and gives me a
#VALUE! error instead. It also does not allow me to enter the {}
brackets. The range is correct and nothing has changed except the
dates.

Any ideas?
 
R

Roger Govier

Hi

It is an array formula.
You don't type the curly braces { } yourself.
When you enter or amend the formula, use Ctrl+Shift+Enter (CSE) not just
Enter.
When you use CSE, Excel will place the braces around the formula.

--
Regards
Roger Govier

Custard Tart said:
I have a holiday spreadsheet that I've used for the last three years
which was passed down to me when I took over this role.

At the top of the spreadsheet, it works out sick days, holiday
allowance, etc. It also works out full days (with the letter H) and
half days (with the letter G). This was the formula that was used:

{=(SUM(IF(C17:D382="g",0.5)))}

The 2010 spreadsheet no longer accepts this formula and gives me a
#VALUE! error instead. It also does not allow me to enter the {}
brackets. The range is correct and nothing has changed except the
dates.

Any ideas?

__________ Information from ESET Smart Security, version of virus
signature database 4527 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4527 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top