Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

IF Function - Reference a column!

0

If C = 1 then  or If C = 2 or 3 (>) then add those monetary amounts for a sum total

=IF(C2:C73=1,SUM('November FY2017 - Q1'!K2:K73+'November FY2017 - Q1'!K2:K27),"")

AND

=IF(C2:C73>1,SUM('November FY2017 - Q1'!K2:K73+'November FY2017 - Q1'!K2:K27),"")

The results would be a dollar amount - I have the formula I use for the Row but can get the column to calculate properly.

Value Received: #VALUE!

Thank you for any information you can provide with this issue.

Answer
Discuss

Answers

0

You need to use an array formula and this is the template for the formula that you should use:

=IF(SUM((A1:A3=2)*1)>0,"hi","bye")

Change A1:A3 to the desired reference.

Make sure to input this formula using Ctrl+Shift+Enter

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login