Solved

Adding formula

Posted on 2011-02-11
1
161 Views
Last Modified: 2012-05-11
Tyring to create a formula that will add the total value in column G1:g80, but the stipulation is the corresponding column D must have "FZ", "-FZ", "+FZ", or VCFZ somewhere in the cell

Example

Column D                        Column G
+FZRA                              .023  
-FZTT                                .12
-TSRA                                .55

total will be .023+.12, do not add .55 since there is no FZ in column D
0
Comment
Question by:sandramac
1 Comment
 
LVL 50

Accepted Solution

by:
Dave Brett earned 500 total points
ID: 34868838
Just
=SUMIF(D1:D80,"*FZ*",G1:G80)

as FZ is common to FZ, -FZ, +FZ and VCFZ

hth

Dave
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

929 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now