Solved

Syntax, sumif

Posted on 2013-02-05
2
171 Views
Last Modified: 2013-02-05
Hi, i get a syntax in the below.  I added iif(A2 = "","", and not sure where I need the parenthesis.  Thank you.  The sumif works fine without the addition.  


=iif(A2 = "","",(SUMIF(Magal!$F$2:$F$200,Summary!A2,Magal!$D$2:$D$200)+SUMIF(Jack!$F$2:$F$201,Summary!A2,Jack!$D$2:$D$201)+SUMIF(Tony!$F$2:$F$200,Summary!A2,Tony!$D$2:$D$200))
0
Comment
Question by:pdvsa
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 400 total points
ID: 38857727
Surely just IF.....?

=IF(A2="","",SUMIF(Magal!$F$2:$F$200,Summary!A2,Magal!$D$2:$D$200)+SUMIF(Jack!$F$2:$F$201,Summary!A2,Jack!$D$2:$D$201)+SUMIF(Tony!$F$2:$F$200,Summary!A2,Tony!$D$2:$D$200))

and perhaps the first A2 should be Summary!A2?

regards, barry
0
 

Author Closing Comment

by:pdvsa
ID: 38857752
Perfect.  thank you barry!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question