The formula’s below have their own resultant cell, and I want it to record a blank until one or more contributing cells in the range for the formula is populated. Right now the resultant cell populates with a zero.
To capture attendance:
=COUNTIFS($D205:$D250,"ATTENDANCE",G205:G250,1)
To Capture the highest rating
=MAX(G217:G252)
To Capture the combined ratings
=SUMIF($D217:$D252,"WEEKLY TOTALS",G217:G252)
Assuming A1 is teh cell to be populates...
=IFA1="","",your-formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
MANY THANKS FOR THE QUICK RESPONSE, however it returned an error. I inserted the range in lieu of A1 as you indicated, would that be the error?
Does it return error if you just use your formula alone in that same cell?
No, it returns a zero as before. More Data: there is 5 cells in a range that are sub-totaled to a zero, then there are 3 ranges. These 3 ranges [vertically] are what is in play. Does that help?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Sure, give me a bit, and thanks for your interest to do so
My expectations is that all the zero's will go away until the contributing cells would start to be populated. Ok, how do I attached the file?
Find it, see attachment
you can try this way
=IFERROR(1/(1/COUNTIFS($B4:$B49,"ATTENDANCE",E4:E49,1)),"")
or more simply custom format cell with formulas
custom
0;-0;;@
incidentaly
=SUM(E4*$C4,E5*$C5,E6*$C6,E7*$C7,E8*$C8,E9*$C9)+SUM(E10*$C10,E11*$C11,E12*$C12)+SUM(E13*$C13,E14*$C14,E15*$C15)
can be just
=SUMPRODUCT(E4:E15,$C$4:$C$15,)
Last edited by martindwilson; 12-27-2014 at 08:58 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Just be aware that if using this formatting the cell will still contain a numeric 0, you just won't see it. That might need to be accounted for in any downstream calculations.Originally Posted by martindwilson
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony,
My spreadsheet is at 85-90 percent completed. I have spent 4 years on it [off and on], at first I was a novice, but probably am now at an intermediate understanding. I need some help to finish this project up within the next 2 months. Since I am unfamiliar with how to go about acquiring a guru off Excel forum. Would you respond and give me the information, and how we could proceed from here.
Thank you
Craig
Last edited by craigl; 02-07-2015 at 02:45 AM.
I assume that means you're interested in hiring someone to help you finish your project.
There is a commercial services section here but I'm not sure how it works. See if this helps:
http://www.excelforum.com/the-water-...-services.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks