IF function

Resolved · Low Priority · Version 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:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips