39 reputation
4
bio website
location
age
visits member for 1 year, 7 months
seen May 22 '13 at 4:09

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