Impact
~790
people reached
- 0 posts edited
- 0 helpful flags
- 3 votes cast
May 22 |
comment |
Using ISBLANK with SUMIF formula
Hi pnuts is it possible to incorporate the "<>#N/A" in a VLOOKUP formula? As an example i currently have a formula VLOOKUP(O301,'Submission 2013-02-19'!$C$11:$D$508,2,FALSE)*1000, which returns no found values. IN my summary page it cant sum the columns as there are approx 50 #N/a entries |
Apr 21 |
comment |
Using ISBLANK with SUMIF formula
With the "<>#N/A" formula though, what logic does it express exactly? |
Apr 21 |
comment |
Using ISBLANK with SUMIF formula
I think you eluded to the problem in your 1st response. I was summing all of column J, which happened to have 2 heading rows. When i changed thew formula to J3:J450 it resolved. |
Apr 19 |
comment |
Using ISBLANK with SUMIF formula
Hi pnuts, i deleted the whole formula and started from scratch and this time it worked. |
Apr 19 |
accepted | Using ISBLANK with SUMIF formula |
Apr 19 |
awarded | Commentator |
Apr 19 |
comment |
Using ISBLANK with SUMIF formula
It still returns #N/A as the total |
Apr 18 |
comment |
Using ISBLANK with SUMIF formula
Hi pnuts, i tried this but with no luck, it still returns N/A has the overall calculation. Does it have something to do with the fact that the #N/A value (and all other values in column J) are the result of a VLOOKUP formula |
Apr 18 |
accepted | How to use IF Formula in excel correctly |
Apr 18 |
accepted | vlookup values displayed month text |
Apr 18 |
asked | Using ISBLANK with SUMIF formula |
Mar 28 |
accepted | Modify formula to work with conditional values |
Mar 28 |
awarded | Supporter |
Mar 28 |
comment |
Concatenate with Spaces
thought it would be something like that, thank you very much |
Mar 28 |
accepted | Concatenate with Spaces |
Mar 27 |
accepted | Complex excel formula help needed? |
Mar 27 |
comment |
vlookup values displayed month text
I apologies for this as I am new to this forum, I will go through and accept all answers i have been using. Thanks for the head sup |
Mar 26 |
asked | vlookup values displayed month text |
Mar 26 |
comment |
Modify formula to work with conditional values
Sorry for the late response but yes i do get other values for new business. The New Business SUMIF check, references new customers who need a meter installed |
Mar 26 |
asked | Concatenate with Spaces |