Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function

IF function

ResolvedVersion 2010

Wed 11 Apr 2018, 13:31 Delegate Ross said...

Ross has attended:
Excel Introduction course
Excel Intermediate course

IF function

I want to sum the numbers in column B (say) according to the values in Column A

I've put
=IF(A:A)=1,Sum(B:B)
This get #NAME
Not sure what I'm doing wrong.
Thanks

Wed 11 Apr 2018, 15:04 Trainer Wendy said...

RE: IF function

Hi Ross

Thank you for your question.

You need to use SUMIF

It consists of 3 areas.

Range: the area you're using to check the criteria (A1:A21)
Criteria: What you're looking for i.e. 1
Sum range: the area that will be calculated (B1:B21)

I wouldn't recommend using the entire column as this will increase your file size and potentially slow down your sheet

Hope this helps

Kind regards
Wendy Canelas
Microsoft Trainer

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

IF function

IF function

RE: IF function

Excel articles

Excel tip:

Importing Numbers in Excel 2010